Always, for every datatype, every single time.
I found a list of dtattypes for most db (the cf docs are poor!) but what about Access? I don't know what mates up with a text or memo field and such.
Thanks.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
stylo stylo said:
Always, for every datatype, every single time.
I found a list of dtattypes for most db (the cf docs are poor!) but
what about Access? I don't know what mates up with a text or memo
field and such.
The datatypes for cfqueryparam are the same as the datatypes in the
JDBC spec
[EMAIL PROTECTED] wrote:
I draw out the date in an Access db and have it in a
text field to change if I want. Resubmitting it worked
fine on cf5. On MX I now get a datatype mismatch
error.
date text: 2004-03-21 09:42:12.0
sql: dateadded = '#dateadded#'
db datatype: date/time
Using
Isn't usertype the name of your query record set? Here you are setting
request.usertype equal to your entire record set (or you would be if you
went without the quotes and hashes.
Request.UserType = #UserType#;
Perhaps you want...
Request.UserType = UserType.usertype[1];
Matthew Walker
Is UserType really a query? Also, why the quotes around 0, and user
type? Also, if user type is a query, it seems kind of dangerous to
sometimes copy it to the request scope as a query, and sometimes as a
string. Ie, you either copy the query, or the string Clinical.
-- Original Message --
From: Bruce Sorge [EMAIL PROTECTED]
You have attempted to dereference a scalar variable of type class java.lang.String as
a structure with members
if (UserType.RecordCount NEQ 0) {
Request.UserType = #UserType#;
}
else {
I may be in the running for today's dumbs**t question. I totally forgot to
create the DSN when I moved the site. Sorry for the wasted bandwidth.
- Original Message -
From: Matthew Walker [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 10, 2003 1:36 PM
Subject: Re: MX
7 matches
Mail list logo