Applying an XML request to a database

Hi Everyone I am interested in how to get an XML request to query a database. I'm working on generating the XML requests OK, I just need to know how XML meets database. Are there any generalised pointers to begin with? Thanks in advance Jonathan Trahair

MySQL and MS SQL Server 2005

Hi Everyone I am now familiar with connecting with MySQL using Visual Basic 6 and ADO. I am about to start a new project which must connect to a customer's MS SQL Server 2005 installation. How safe/unsafe is my assumption that as far as SQL strings and ADO connections are concerned 'if it

Re: MySQL and MS SQL Server 2005

: - SQL Server doesn't support LIMIT clause; - Don't use quotes for numerical values as it works on MySQL only; - In GROUP BY clause, list all not aggregated columns you are selecting; - Use single quotes for strings; Hope it helps. On 1/23/08, J Trahair [EMAIL PROTECTED] wrote: Hi Everyone I

Re: Spawning Tables

In my experience, having a limit of a particular number of anythings per something, eg. components per compound word is always a mistake, whether it's the number of payments allowed to pay an invoice, the number of children per parent, the number of cars per family, pets per owner, etc. There's

Re: Update but insert if not exist

This is a question I want to know the answer to, as well! Is there any way of avoiding looking up a specific record in a table to see if it exists, before deciding whether to INSERT INTO or UPDATE, eg: mstrSQL = SELECT * FROM Shops WHERE ShopReference = ' grd1.TextMatrix(numRowNo, 1) '

Limit SET command to 2 decimal places

Hi Everyone I have a database with an OrderItems table, containing (at least) 3 fields, namely ExtendedPurchasePrice, CurrencyConversion and ExtendedPurchasePriceSterling, all fields as doubles. I want to update ExtendedPurchasePriceSterling for each row with the result of the calculation

Re: preferred way to backup a 20GB MySQL database

What about the MySQL Administration backup routine, which can be scheduled for a convenient time? No-one has mentioned this one. We use it but perhaps there is something I should know...? Thanks Jonathan Trahair - Original Message - From: B. Keith Murphy To: Dan Buettner Cc:

Scheduled backups

Hi Everyone I have set up a scheduled backup using MySQL Administrator. Stored connection, database, dates and time, even the Windows user password (in fact, blank). It doesn't start at the correct time, or indeed any time. Have I missed something? Thanks for your help. Jonathan Trahair

Error message on trying to start service

Hi Everyone I had to re-install everything after Norton crashed my hard disk. I re-formatted. I am trying to install MySQL using the same installation files and method as before. MySQL installed OK (mysql-5.0.27-win32.zip). The mysql connector ODBC installed OK. However, I cannot complete

Fw: Error message on trying to start service

Thanks Baron, that hit the spot. Thanks again. Jonathan - Original Message - From: J Trahair To: MySQL General Sent: Saturday, May 05, 2007 9:00 PM Subject: Error message on trying to start service Hi Everyone I had to re-install everything after Norton crashed my hard disk. I re