input type="hidden" name="id" value="selectcandidate"
doesn't the value need # symbols?
-paul
Web Developer, NBBJ
Work: [EMAIL PROTECTED]
614 241-3534
fax:614 485-5534
Home: [EMAIL PROTECTED]
614 449-1681
icq: 47658358
-Original Message-
From: Mike
It would be best if u can tell us what the problem is and what ua re tyring
to get the page to do. then i can understand the code better
-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 1:27 PM
To: CF-Talk
Subject: Code review, PLEASE
I have
Sorry bout that:
This is the error
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE
statement.
The error occurred while
glad you said that, i was feeling kind of dense
"Dylan Bromby" [EMAIL PROTECTED] on 03/19/2001 01:39:53 PM
Please respond to [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
cc:(bcc: Savan Thongvanh/DSM/Seabury)
Subject: RE: Code review, PLEASE
why don't you p
This is what I get now with the ##
Error Occurred While Processing Request
Error Diagnostic Information
Expression result cannot be converted to a string
Expressions used inside tags like CFOUTPUT, CFQUERY, CFMAIL, etc. must
evaluate to a value that can be converted to a string
whats the error that you are getting with this code?
- Original Message -
From: "Mike" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, March 19, 2001 2:26 PM
Subject: Code review, PLEASE
I have to be missing something: and I cant put my mouse on it
!DOCTYPE HTML
selectCandidate is your query name; a query can't be converted to a string.
You may want one of your query column names instead.
-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 2:01 PM
To: CF-Talk
Subject: Re: Code review, PLEASE
This is what I
I don't see any query that is updating anything in
the code you sent.
-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 1:51 PM
To: CF-Talk
Subject: Re: Code review, PLEASE
Sorry bout that:
This is the error
Error Occurred While Processing Request
iginal Message-
From: Mike [SMTP:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 3:01 PM
To: CF-Talk
Subject: Re: Code review, PLEASE
This is what I get now with the ##
Error Occurred While Processing Request
Error Diagnostic Information
Expression result cannot
ue="#id"
... rest of code...
/cfoutput
-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 2:01 PM
To: CF-Talk
Subject: Re: Code review, PLEASE
This is what I get now with the ##
Error Occurred While Processing Request
Error Diagnostic In
change mawrows = 1 to something else, like user definable.
Alexander Sicular
Technical Director, Information Technology
The Neurological Institute of New York
Columbia University
212.305.1318
[EMAIL PROTECTED]
-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Thursday,
Your the second one to say that, but locally everything works fine, if I
turn the max rows off then I will see all the records and I only want to see
one record at time
Michael
"Cami Lawson" [EMAIL PROTECTED] wrote in message
010001c0ad87$6836dcb0$[EMAIL
Are you trying to have the user page through one record at a time? Cause
that's what you're going to get with this. You'll only ever get one user
whose id equals the passed id
---snip--- WHERE ID=#ID#
What I think you want is something like the following (quickly cut from
existing code, so
, March 15, 2001 2:47 PM
To: CF-Talk
Subject: Re: Code review PLEASE
Your the second one to say that, but locally everything works fine, if I
turn the max rows off then I will see all the records and I only want to see
one record at time
Michael
"Cami Lawson" [EMAIL PROTEC
From: "Mike" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, March 15, 2001 14:46
Subject: Re: Code review PLEASE
Your the second one to say that, but locally everything works fine, if I
turn the max rows off then I will see all the records and I only want to
see
OK my miss understanding, another developer showed me the prev and next
code and when they did, they told me that I didnt need the max rows anymore.
Although I question why it worked fine on the local machine and not when
posted?
THANK YOU
MICHAEL
egg on my face
"Cami Lawson" [EMAIL
t a string, and
is in fact a number after you increment it.
Douglas Malcolm
-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 11:47 AM
To: CF-Talk
Subject: Re: Code review PLEASE
Your the second one to say that, but locally everything works fine,
At 02:46 PM 3/15/01 -0500, you wrote:
Your the second one to say that, but locally everything works fine, if I
turn the max rows off then I will see all the records and I only want to see
one record at time
Michael
The problem isn't with maxrows, it's with ID. the cfparam statement isn't
Put CFOUTPTUT around the CFSET for your NEXT/PREV variables
Your MAXROWS=1 is fine
-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 2:47 PM
To: CF-Talk
Subject: Re: Code review PLEASE
Your the second one to say that, but locally everything works
Take maxrows out of the cfquery and add it to the cfoutput along with a
startrow attribute.
Jason
- Original Message -
From: "Mike" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, March 15, 2001 12:46 PM
Subject: Re: Code review PLEASE
Your t
logies, Inc.
want CF_Freedom?
try CFXHosting.com
-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 2:47 PM
To: CF-Talk
Subject: Re: Code review PLEASE
Your the second one to say that, but locally everything works fine, if I
turn the m
Mike do a little debugging on the host. What is the value of #nextid# and
#previd# on the page? When you click next on the host, does it show the
first record everytime? Does the url always say default2.cfm?ID=2 ?
If so, it's obvious that the sql statement is not picking up the url
variable and
, March 15, 2001 2:47 PM
To: CF-Talk
Subject: Re: Code review PLEASE
Your the second one to say that, but locally everything works fine, if I
turn the max rows off then I will see all the records and I only want to
see
one record at time
Michael
"Cami Lawson" [EMAIL
THank You Jon, I am trying some of what other's here on the list suggested
also.
Michael
"Jon Hall" [EMAIL PROTECTED] wrote in message
028701c0ad91$fd121de0$a41f88d8@ns2">news:028701c0ad91$fd121de0$a41f88d8@ns2...
Mike do a little debugging on the host. What is the value of #nextid# and
24 matches
Mail list logo
