SQL with Xquery problem :: MySQL / MS SQL :: Discussion Forum :: Networks

Networks » Discussion Forum » MySQL / MS SQL » SQL with Xquery problem

JavaScript is not enabled on your browser and in order to properly use Coder Profile JavaScript is required.
To view instructions on how to enable JavaScript on your browser click here.

Posted: 2.42 Years Ago

Caverax
Canada

Contrib Level: 5
Total Posts: 139

Ok so, first of all, what I want is a list of Appointments by a contact name.

The structure is : The table Appointment contains Multiple contacts serialized in a xml column.

The xml column only contains the contact ID. The table named contact contain the contact id and the contactName from wich I wanna search by.

this is an example of the xml column.

CODE:	Copy / Restore :: Remove Scroll Bars
<ArrayOfContactsInfos> <ContactsInfos> <ContactID>1</ContactID> </ContactsInfos> <ContactsInfos> <ContactID>2</ContactID> </ContactsInfos> </ArrayOfContactsInfos>

So basically, how could I get a list of appointment by the contact name. The search for contact name is that kind %ContactName% So there could be more than one contact name (id) to check if it exist in the appointment..

It is kinda hard to explain, so I'll just hope you understood,
Thanks,
Caverax

Reply With Quote

Page 1 of 1

Latest News About Coder Profile

RSS News Feed

Coder Profile Poll

Why do you get bored with programming?

Not enough time to do something productive
I run out of ideas
Too hard to show people my creations
Everything i do has too many errors, and it's too hard
I don't get bored!!!

please login to cast your vote
and see the results of this poll

Latest Coder Profile Changes

Coder Profile was last updated
3.49 Years Ago

RSS Development Blog Feed

Official Blog :: Make A Donation :: Credits :: Contact Me
Terms & Conditions :: Privacy Policy :: Documents :: Wallpapers