RE: strange SQL error

2002-06-06 Thread Bryan Love
do this: cfquery name=Update datasource=#Form.DSN# Update #preserveSingleQuotes(Form.Tablename)# SET #preserveSingleQuotes(FieldNameValues)# WHERE ID = #preserveSingleQuotes(Form.ID)# /cfquery +---+ Bryan Love Macromedia Certified Professional

RE: Strange SQL error

2002-05-17 Thread Rich Wild
I assume in this bit: VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID you're actually using VALUES ( @CountryID ,

RE: Strange SQL error

2002-05-17 Thread Andy Ewings
ah - yes sorry - forgot to change it back -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:50 To: CF-Talk Subject: RE: Strange SQL error I assume in this bit: VALUES ( @CountryID , @JuryName , @test

RE: Strange SQL error

2002-05-17 Thread Andy Ewings
Right fixed it - all we did was to move the declaration of the JuryTitle param to the bottom of the list and itr works! SQL schmeequel -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:50 To: CF-Talk Subject: RE: Strange SQL error I assume in this bit

RE: Strange SQL error

2002-05-17 Thread Rich Wild
uh? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 17:18 To: CF-Talk Subject: RE: Strange SQL error Right fixed it - all we did was to move the declaration of the JuryTitle param to the bottom of the list and itr works! SQL schmeequel

RE: Strange SQL error

2002-05-17 Thread Stephen Galligan
-Talk Subject: RE: Strange SQL error uh? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 17:18 To: CF-Talk Subject: RE: Strange SQL error Right fixed it - all we did was to move the declaration of the JuryTitle param to the bottom of the list

RE: Strange SQL error

2002-05-17 Thread Margaret Fisk
code through notepad if I've touched anything like Word or Wordpad for example because of the illegal characters. Margaret -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 9:25 AM To: CF-Talk Subject: RE: Strange SQL error What Andy meant

RE: Strange SQL Error...

2001-04-04 Thread Costas Piliotis
Try: SQL = 'UPDATE tbl2inspectorformgeneration SET inspected = ''5/5/1''' Single quotes make strings, not double quotes. Two single quotes together makes for a single quote inside of a string. -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04,

RE: Strange SQL Error...

2001-04-04 Thread Hayes, David
Do you have an update trigger on the table? -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 2:33 PM To: CF-Talk Subject: Strange SQL Error... Has anyone seen this? There are no "subqueries" going on in this SQL statement.. But yet we get

RE: strange SQL error code

2000-11-08 Thread Hoffman, Joe (CIT)
What version ODBC driver are you using? http://support.microsoft.com/support/kb/articles/q234/9/87.asp INFO: SQL Server Driver Version 3.70 May Return Fractional Truncation Message When Processing DateTime Parameter Joe Hoffman mailto:[EMAIL PROTECTED] National Institutes of Health Center

RE: strange SQL error code

2000-11-08 Thread Anthony Geoghegan
On that note, does anyone have a list of Microsoft SQL Error Codes? They are listed in the online books online-reference. If you like I'll post you a text file offlist. Regards, Anthony Geoghegan. Lead Developer, What's On Where (WOW!) http://www.wow.ie mailto:[EMAIL PROTECTED]