Here are my standard steps for dealing with tough query problems:
1) View the CF-generated SQL statement by turning on debugging (or by just
<cfoutput> -ing the code instead of <cfquery> -ing it.
2) Look at the generated statement for obvious errors.
3) Try to run the generated SQL directly in your db, using some db tool
(e.g., Enterprise Manager)
4) Debug in the db, rather than in CF.
-----Original Message-----
From: Jon Tillman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 12:43 PM
To: CF-Talk
Subject: query trouble
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I cannot for the life of me figure out what is wrong with this query. I am
getting a Syntax Error or Access Violation Error:
<cfquery name="setup" datasource="#application.dsn#">
INSERT INTO tblClient
(ClientTemplateID, ClientDomain, ClientDomainAction,
ClientPackage, ClientTerms, ClientAddress_1,
ClientAddress_2, ClientCity, ClientState, ClientPostalCode,
ClientCountry, ClientPhone, ClientPhone_2, ClientEmail,
ClientFName, ClientMI, ClientLName, ClientCCNumber,
ClientCCExpire, ClientCCType, ClientComments,
ClientLogin, ClientPassword, ClientNew, ClientPrice)
VALUES (#session.TemplateID#, '#session.Domain#',
'#session.DomainAction#', #session.package#,
'#session.terms#', '#session.Address_1#',
'#session.Address_2#', '#session.City#',
'#session.State#', #session.PostalCode#,
'#session.Country#', #session.Phone#,
#session.Phone2#, '#session.Email#',
'#session.FName#', '#session.MI#',
'#session.LName#', #Right(session.CCNumber, 4)#,
#CreateODBCDateTime(CreateDate(session.CCexpYr,
session.CCexpMo, 1))#,
'#session.CCType#', '#session.Conmments#',
'#session.Email#', '#password#', 'yes',
#application.packageprice#)
</cfquery>
Any help would be much appreciated.
- --
Jon Tillman
http://www.eruditum.org
Next thing they'll want is a word-processor that auto-updates quake
mods, gets stock quotes, waters the office plants, walks their dog,
orders a pizza, and is connected to a client/employee database.
-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.1i
iQA/AwUBOsIwxtga7tZtnIOtEQK4ZQCeLwq7ZA3B8XpP+dvqLXeieDZO9eYAniLZ
LWIucx8XRxjBQUe3/rvimj22
=EKA8
-----END PGP SIGNATURE-----
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
