What type of field is the "ClientNew" field? Some databases store "yes" values as 1's
or 0's - maybe you are
mixing data types.
~Becky
Jon Tillman wrote:
> -----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
