-----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
