> Carl, does cfparam as you described discretely tell CF and
> SQL that the insert is a numerical data type? In what
> instances is that advised? Why is it necessary?
http://www.adobe.com/devnet/coldfusion/articles/cfqueryparam.html
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fi
Thanks all.
Carl, does cfparam as you described discretely tell CF and SQL that the insert
is a numerical data type? In what instances is that advised? Why is it
necessary?
I've isolated the issue to a server memory problem, I believe, and solved it (I
hope)
by restarting the server.
Thank
John,
You might want to try using CFQUERYPARAM in your insert query. Something like:
INSERT INTO STUDENT_ACADEMICS (CUM_GPA)
VALUES ()
Set the CFSQLTYPE to the appropriate type to match the data type of the SQL
field.
HTH,
Carl
> Form code:
>
> required="Yes" size="8">...
>
> Insert:
>
Unfortunately the failed inserts are random for different users, unique fields,
it's a pretty large application. I'd rather that it work correctly but I'll
take your suggestion into consideration worse case senario.
>Could you:
>
>
>
>
>
>What the hell is goin on here??
>
>
>
>
>
>redirect
Could you:
What the hell is goin on here??
redirect user letting them know there's a problem
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275823
Subscription: http://www.houseoffusion.com/groups/CF
That's correct, worse still, the issue seems random. I've had other users who
have been unsuccessful at submitting variables which have worked for me each
time I've tested. At first I thought it might be a session issue, but the
example above is a form variable. For some reason Cum_GPA isn't mak
and you're not getting any errors? the other values in the statement
are inserting fine but you get an empty field for CUM_GPA?
On 4/18/07, John P <[EMAIL PROTECTED]> wrote:
> CUM_GPA does pass with on the action page.
>
> I am inserting other records with this insert statement, I left them out
CUM_GPA does pass with on the action page.
I am inserting other records with this insert statement, I left them out of my
post for clarity. Yes this is a new insert not an update.
>can you do a on top of action.cfm and make sure
>a value (and the value you expect) is being passed?
>
>also.
can you do a on top of action.cfm and make sure
a value (and the value you expect) is being passed?
also... you're just inserting a single record? not trying to update a
particular existing record?
On 4/18/07, John P <[EMAIL PROTECTED]> wrote:
> Form code:
>
> size="8">...
>
> Insert:
>
>
Form code:
...
Insert:
INSERT INTO STUDENT_ACADEMICS (CUM_GPA)
VALUES ('#TRIM(FORM.CUM_GPA)#')
CUM_GPA is not being inserted for me, however other users have had different
data that is lost. This variable is NOT being stored as a session variable.
Thx John
>can you post the form
can you post the form code, insert code, and variable values that did
not insert properly?
On 4/18/07, John P <[EMAIL PROTECTED]> wrote:
> Coldfusion updates that were performed were 7.0.1 and 7.0.2
>
> I'm researching but does anyone know if these updates affected session
> variables?
>
> Thx
>
Coldfusion updates that were performed were 7.0.1 and 7.0.2
I'm researching but does anyone know if these updates affected session
variables?
Thx
John
> Hi All,
>
> I'm maintaining a Coldfusion Application which is storing form data in
> an MSSQL database.
>
> We've recently received c
Hi All,
I'm maintaining a Coldfusion Application which is storing form data in an MSSQL
database.
We've recently received complaints from users that not all form data is being
inserted to the database. The issue appears to be random. I've tested 4 times
and found that only one of my fields i
13 matches
Mail list logo
