Disregard that I realized when I was fixing the page I added and extra '
Problem solved thank you I'll see if the report now shows the correct date
on submission.
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
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\vorema
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,
time
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 sta
Use CFQUERYPARAM and your problems will vanish. MySQL is picky about
using strings as date literals, so it's getting screwed up. CF
formats the default MySQL date value (-00-00 00:00:00) as 11/30/02
for some reason. If you look in the DB, it'll be all zeros though.
cheers,
barneyb
On Mon,
After switching a cold fusion application from an access database to mysql
I have some strange problems that I am not 100% sure on. Image issues no
thumbnails showing up I assume it's related to the original storage
location of the images. However one issue I can't seem to correct and has
me st
Might I suggest looking at the use of the onUnload attribute of the html
tag?
Regards
Stephen
- Original Message -
From: "Tangorre, Michael T." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, November 25, 2001 3:15 PM
Subject: Datest
al Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 25, 2001 3:16 PM
To: CF-Talk
Subject: Datestamp
Is there a way to insert a datestamp into a SQL Server DB when the user
closers their browser or goes to a different site?
I am tyring to get a timestamp whe
> Is there a way to insert a datestamp into a SQL Server DB when the user
> closers their browser or goes to a different site?
> I am tyring to get a timestamp when the user leaves the site either by
> closing the browser down, going to a new site, or a session timing out.
In the lo
me
browser version
os name
os version
lastVisited
screen height
screen resolution
pages visited
javascript enabled
db
- Original Message -
From: "Tangorre, Michael T." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, November 25, 2001 7:15 A
Is there a way to insert a datestamp into a SQL Server DB when the user
closers their browser or goes to a different site?
I am tyring to get a timestamp when the user leaves the site either by
closing the browser down, going to a new site, or a session timing out.
Is this possible?
Michael T
11 matches
Mail list logo