I'm doing some testing with MS Access and CFMBB... and I can't even get past
the install/setup... the following query generates a syntax error:
insert into cfmbb_users ( id, username, password, emailaddress, datecreated,
signature, avatar_url, location, confirmed, active) values ( (param 1) ,
(param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) ,
(param 8) , (param 9) , (param 10) )
Here is the coldfusion code:
<cfquery name="insuser" datasource="#variables.dsn#">
insert into #variables.tableprefix#users
( id, username, password, emailaddress, datecreated, signature,
avatar_url, location, confirmed, active)
values
(
<cfqueryparam value="#createUUID()#" cfsqltype="CF_SQL_VARCHAR"
maxlength="35">,
<cfqueryparam value="#arguments.username#" cfsqltype="CF_SQL_VARCHAR"
maxlength="100">,
<cfif variables.settings.encryptPasswords is 1>
<cfqueryparam value="#hash(arguments.password)#"
cfsqltype="CF_SQL_VARCHAR" maxlength="50">,
<cfelse>
<cfqueryparam value="#arguments.password#" cfsqltype="CF_SQL_VARCHAR"
maxlength="100">,
</cfif>
<cfqueryparam value="#arguments.emailaddress#"
cfsqltype="CF_SQL_VARCHAR" maxlength="255">,
<cfqueryparam cfsqltype="CF_SQL_TIMESTAMP"
value="#dateConvert("local2utc",now())#">,
<cfqueryparam value="" cfsqltype="CF_SQL_VARCHAR">,
<cfqueryparam value="" cfsqltype="CF_SQL_VARCHAR">,
<cfqueryparam value="" cfsqltype="CF_SQL_VARCHAR">,
<cfqueryparam value="0" cfsqltype="CF_SQL_SMALLINT">,
<cfqueryparam value="1" cfsqltype="CF_SQL_SMALLINT">
)
</cfquery>
And here are the params reported by cferror....
(param 1) = [type='IN', class='java.lang.String',
value='512B3AF1-1018-064D-47885EA21121B37F', sqltype='CF_SQL_VARCHAR'] ,
(param 2) = [type='IN', class='java.lang.String', value='admin',
sqltype='CF_SQL_VARCHAR'] ,
(param 3) = [type='IN', class='java.lang.String', value='admin',
sqltype='CF_SQL_VARCHAR'] ,
(param 4) = [type='IN', class='java.lang.String', value='[EMAIL PROTECTED]',
sqltype='CF_SQL_VARCHAR'] ,
(param 5) = [type='IN', class='java.sql.Timestamp', value='2007-03-14 15:57:
39.441', sqltype='CF_SQL_TIMESTAMP'] ,
(param 6) = [type='IN', class='java.lang.String', value='',
sqltype='CF_SQL_VARCHAR'] ,
(param 7) = [type='IN', class='java.lang.String', value='',
sqltype='CF_SQL_VARCHAR'] ,
(param 8) = [type='IN', class='java.lang.String', value='',
sqltype='CF_SQL_VARCHAR'] ,
(param 9) = [type='IN', class='java.lang.Integer', value='0',
sqltype='CF_SQL_SMALLINT'] ,
(param 10) = [type='IN', class='java.lang.Integer', value='1',
sqltype='CF_SQL_SMALLINT']
Can anyone tell what's going on?
--
Join the Open Source Coldfusion NCAA Pool for a chance to win a 2 gig USB
flash drive!
http://www.opensourcecf.com/forums/ncaapool.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272663
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
