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
I assume in this bit:
VALUES (
@CountryID
, @JuryName
, @test
, @JuryCompany
, @JuryCity
, @JuryTypeID
you're actually using
VALUES (
@CountryID
,
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
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
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
-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
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
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,
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
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
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]
11 matches
Mail list logo