Now when attempting to submit an offer I get new errors ones I'm not
particularly familiar with.
The cause of this output exception was that:
coldfusion.runtime.Cast$DateStringConversionException: The value
"'14:55:43" could not be converted to a date..
The error occurred in C:\Inetpub\voremarketing\zincludes\offerForm.cfm: line 61
Called from C:\Inetpub\voremarketing\search\itemDetail.cfm: line 130
Called from C:\Inetpub\voremarketing\search\itemDetail.cfm: line 118
Called from C:\Inetpub\voremarketing\search\itemDetail.cfm: line 78
Called from C:\Inetpub\voremarketing\search\itemDetail.cfm: line 1
Called from C:\Inetpub\voremarketing\zincludes\offerForm.cfm: line 61
Called from C:\Inetpub\voremarketing\search\itemDetail.cfm: line 130
Called from C:\Inetpub\voremarketing\search\itemDetail.cfm: line 118
Called from C:\Inetpub\voremarketing\search\itemDetail.cfm: line 78
Called from C:\Inetpub\voremarketing\search\itemDetail.cfm: line 1
59 : 'WEB USER',
60 : <cfqueryparam cfsqltype="cf_sql_date"
value="#theDate#" />,
61 : <cfqueryparam cfsqltype="cf_sql_time"
value="'#theTime#" />)
62 :
63 : </cfquery>
At 02:35 PM 12/20/2004, you wrote:
>Sorry about that. You use CFQUERYPARAM to wrap the values you pass
>into your query. So instead of this;
>
>INSERT INTO myTable
> (agent,
> dateEntered,
> timeEntered
> )
>VALUES
> ('WEB USER',
> '#theDate#',
> '#theTime#'
> )
>
>you'd do this:
>
>INSERT INTO myTable
> (agent,
> dateEntered,
> timeEntered
> )
>VALUES
> ('WEB USER',
> <cfqueryparam cfsqltype="cf_sql_date" value="#theDate#" />,
> <cfqueryparam cfsqltype="cf_sql_time" value="'#theTime#" />
> )
>
>CFQUERYPARAM is your friend. Use it everywhere. It saves enormous
>hassles, and helps protect you.
>
>cheers,
>barneyb
>
>On Mon, 20 Dec 2004 13:54:24 -0700, Jason Smith
><[EMAIL PROTECTED]> wrote:
> > I've been reading about CFQUERYPARAM
> > to see where this needs to be inserted to fix my date problem but I am
> > new to CF and I'm most likely overlooking a simple solution can anyone
> > pointme in the right direction or a site that has some better tutorial type
> > information about storing date/time stamps correctly?
> >
>
>--
>Barney Boisvert
>[EMAIL PROTECTED]
>360.319.6145
>http://www.barneyb.com/blog/
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188335
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
