Looks like your problem may be in setting the Age column, which I'm assuming is
probably a numeric type column in your database. You need to remove the quotes so
that you do
Age = #form.age#
instead of
Age = '#form.age#'
You may also need to do some data validation, as the input field you're using will
allow someone to enter characters where you want them to enter numbers. You could use
CFFORM & CFINPUT, which will give you some javascript validation capabilities without
much effort.
Regards,
Troy Leaver
Systems Development Consultant
Solution Specialists, Inc.
---------- Original Message ----------------------------------
From: "Tony Hicks" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Tue, 5 Dec 2000 14:40:27 -0600
>This is a multi-part message in MIME format.
------=_NextPart_000_002C_01C05EC9.4FF57E20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello,
I'm looking for someone who might help me with updating a databse... =
here's the background information on what I'm doing... I was recently =
introduced to the great forums, called hotscripts... and wanted to start =
a similar indexer and then saw the prices of the good ones and my jaw =
dropped so I took what I knew of cold fusion and WA-LA I have a great =
indexer but the problem is that I've added profiles and they work great =
to... but I cannot make the page update profile information no matter =
what I do...
here's the source of the page with the update form on it:
-------------------------------------------------------------------------=
-------
<cfquery name=3Dreadprofiles datasource=3DCommunity>
select * from members where username=3D'#un#'
</cfquery>
<cfoutput query=3D"readprofiles">
<form action=3D"index.cfm?job=3Dpsecond&ID=3D#ID#" method=3Dpost> <table =
cellpadding=3D0 cellspacing=3D0 bgcolor=3Dwhite border=3D0 width=3D100%>
<tr>=20
<td bgcolor=3Dblack bordercolor=3Dwhite><font size=3D2 face=3DArial =
color=3Dwhite>#un#'s Profile</font></td>
</tr>
<tr>
<td bgcolor=3Dwhite bordercolor=3Dwhite>
<P align=3D"right"><b>Name:</b> <cfif un is "#username#" and pword is =
"#password#"><input type=3Dtext name=3DName value=3D"</cfif>#Name#<cfif =
un is "#username#" and pword is "#password#">"></cfif><BR>
<b>Location:</b> <cfif un is "#username#" and pword is =
"#password#"><input type=3Dtext name=3Dlocation =
value=3D"</cfif>#Location#<cfif un is "#username#" and pword is =
"#password#">"></cfif><BR>
<b>Age:</b> <cfif un is "#username#" and pword is "#password#"><input =
type=3Dtext name=3Dage value=3D"</cfif>#Age#<cfif un is "#username#" and =
pword is "#password#">"></cfif><BR>
<b>Gender:</b> <cfif un is "#username#" and pword is =
"#password#"><input type=3Dtext name=3Dgender =
value=3D"</cfif>#Gender#<cfif un is "#username#" and pword is =
"#password#">"></cfif><BR>
<b>Interests:</b> <cfif un is "#username#" and pword is =
"#password#"><textarea name=3Dinterests></cfif>#Interests#<cfif un is =
"#username#" and pword is "#password#"></textarea></cfif><BR>
<b>Home Page:</b> <cfif un is "#username#" and pword is =
"#password#"><input type=3Dtext name=3Dmyurl =
value=3D"</cfif>#myurl#<cfif un is "#username#" and pword is =
"#password#">"></cfif><cfif un is "#username#" and pword is =
"#password#"><input type=3Dtext name=3Dmyhomepage =
value=3D"</cfif>#myhomepage#<cfif un is "#username#" and pword is =
"#password#">"></cfif></P>
</td>
</tr>
<tr>
<td bgcolor=3Dblack>
<div align=3Dright><font size=3D1>�<input type=3Dsubmit =
name=3D"profile_action" value=3D"Update"></font></div>
</table>
</form>
</cfoutput>
-------------------------------------------------------------------------=
-------
As you can see the page is written so that if just anyone views it, its =
written so that it just shows the information but if the owner of that =
profile logs in and views it, he can alter his profile easily.... the =
page submits to job=3Dpmain (pmain.cfm) which contains
-------------------------------------------------------------------------=
-------
<cfquery name=3Dupdateprofiles datasource=3DCommunity>
update Members
set Name=3D'#form.name#',
Age=3D'#form.age#',
Location=3D'#form.Location#',
Interests=3D'#form.Interests#',
Gender=3D'#form.Gender#'
where ID=3D'#ID#'
</cfquery>
Profile Successfully Changed
-------------------------------------------------------------------------=
-------
and then no matter what i do i recieve this error:
-------------------------------------------------------------------------=
-------
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code =3D 22005 (Error in assignment)=20
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in =
criteria expression.=20
The error occurred while processing an element with a general =
identifier of (CFQUERY), occupying document position (1:1) to (1:50).
Date/Time: 12/05/00 14:14:44
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
Remote Address: 127.0.0.1
HTTP Referer: =
http://localhost/projects/Community/index.cfm?job=3Dpmain&un=3DBobbo&unam=
e=3Dbobbo&pword=3Dmoo&login_action=3DLogin
Query String: job=3Dpsecond=20
=20
any clue on what I can do to fix this?
Thanks,
Tony Hicks
Professionally Designed Websites
http://www.righteousdesigns.com
ICQ: 5874143 AIM: Webmigit Y!: Webmigit
mailto:[EMAIL PROTECTED]
Tired of your web host?
http://www.nextmill.net
Need a Domain? Don't have a credit card?
http://www.domainsbycheck.com
Got your Free Online Business Card Yet?
Here's mine: http://thecardfile.com/webmigit.htm
------=_NextPart_000_002C_01C05EC9.4FF57E20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hello,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>�</DIV>
<DIV><FONT face=3DArial size=3D2>I'm looking for someone who might help =
me with=20
updating a databse... here's the background information on what I'm =
doing... I=20
was recently introduced to the great forums, called hotscripts... and =
wanted to=20
start a similar indexer and then saw the prices of the good ones and my =
jaw=20
dropped so I took what I knew of cold fusion and WA-LA I have a great =
indexer=20
but the problem is that I've added profiles and they work great to... =
but I=20
cannot make the page update profile information no matter what I=20
do...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>�</DIV>
<DIV><FONT face=3DArial size=3D2>here's the source of the page with the =
update form=20
on it:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>
<HR>
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><cfquery name=3Dreadprofiles=20
datasource=3DCommunity><BR>select * from members where=20
username=3D'#un#'<BR></cfquery></FONT></DIV>
<DIV>�</DIV>
<DIV><FONT face=3DArial size=3D2><cfoutput =
query=3D"readprofiles"><BR><form=20
action=3D"index.cfm?job=3Dpsecond&ID=3D#ID#" method=3Dpost> =
<table=20
cellpadding=3D0 cellspacing=3D0 bgcolor=3Dwhite border=3D0 =
width=3D100%><BR>�=20
<tr> <BR>��� <td bgcolor=3Dblack=20
bordercolor=3Dwhite><font size=3D2 face=3DArial =
color=3Dwhite>#un#'s=20
Profile</font></td><BR>� </tr><BR>�=20
<tr><BR>��� <td bgcolor=3Dwhite=20
bordercolor=3Dwhite><BR><P =
align=3D"right"><b>Name:</b>=20
<cfif un is "#username#" and pword is "#password#"><input =
type=3Dtext=20
name=3DName value=3D"</cfif>#Name#<cfif un is "#username#" and =
pword is=20
"#password#">"></cfif><BR><BR>�=20
<b>Location:</b> <cfif un is "#username#" and pword is=20
"#password#"><input type=3Dtext name=3Dlocation=20
value=3D"</cfif>#Location#<cfif un is "#username#" and pword is =
"#password#">"></cfif><BR><BR>� =
<b>Age:</b>=20
<cfif un is "#username#" and pword is "#password#"><input =
type=3Dtext=20
name=3Dage value=3D"</cfif>#Age#<cfif un is "#username#" and =
pword is=20
"#password#">"></cfif><BR><BR>�=20
<b>Gender:</b> <cfif un is "#username#" and pword is=20
"#password#"><input type=3Dtext name=3Dgender=20
value=3D"</cfif>#Gender#<cfif un is "#username#" and pword is=20
"#password#">"></cfif><BR><BR>�=20
<b>Interests:</b> <cfif un is "#username#" and pword is=20
"#password#"><textarea =
name=3Dinterests></cfif>#Interests#<cfif=20
un is "#username#" and pword is=20
"#password#"></textarea></cfif><BR><BR>� =
<b>Home=20
Page:</b> <cfif un is "#username#" and pword is=20
"#password#"><input type=3Dtext name=3Dmyurl=20
value=3D"</cfif>#myurl#<cfif un is "#username#" and pword is=20
"#password#">"></cfif><cfif un is "#username#" and pword =
is=20
"#password#"><input type=3Dtext name=3Dmyhomepage=20
value=3D"</cfif>#myhomepage#<cfif un is "#username#" and pword =
is=20
"#password#">"></cfif></P><BR>� =
</td><BR>�=20
</tr><BR>� <tr><BR>� <td =
bgcolor=3Dblack><BR>�=20
<div align=3Dright><font size=3D1> <input =
type=3Dsubmit=20
name=3D"profile_action"=20
value=3D"Update"></font></div><BR>�</table><BR>=
</form><BR></cfoutput></FONT></DIV>
<DIV>
<HR>
</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>�</DIV>
<DIV><FONT face=3DArial size=3D2>As you can see the page is written so =
that if just=20
anyone views it, its written so that it just shows the information but =
if the=20
owner of that profile logs in and views it, he can alter his profile =
easily....=20
the page submits to job=3Dpmain (pmain.cfm) which contains</FONT></DIV>
<DIV>
<HR>
</DIV>
<DIV><FONT face=3DArial size=3D2><cfquery name=3Dupdateprofiles=20
datasource=3DCommunity><BR>update Members<BR>set=20
Name=3D'#form.name#',<BR>�����=20
Age=3D'#form.age#',<BR>�����=20
Location=3D'#form.Location#',<BR>�����=20
Interests=3D'#form.Interests#',<BR>�����=20
Gender=3D'#form.Gender#'<BR>where =
ID=3D'#ID#'<BR></cfquery><BR>Profile=20
Successfully Changed</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>
<HR>
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>�</DIV>
<DIV><FONT face=3DArial size=3D2>and then no matter what i do i recieve =
this=20
error:</FONT></DIV>
<DIV>
<HR>
</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>�</DIV>
<DIV><FONT face=3DArial size=3D2>
<H3>Error Occurred While Processing Request</H3>
<P>
<TABLE border=3D1>
<TBODY>
<TR>
<TD>
<H4>Error Diagnostic Information</H4>
<P>ODBC Error Code =3D 22005 (Error in assignment)=20
<P>
<P>[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in =
criteria expression.=20
<P>
<P>
<P>The error occurred while processing an element with a general=20
identifier of (CFQUERY), occupying document position (1:1) to =
(1:50).</P>
<P>
<P>Date/Time: 12/05/00 14:14:44<BR>Browser: Mozilla/4.0 =
(compatible; MSIE=20
5.5; Windows 98)<BR>Remote Address: 127.0.0.1<BR>HTTP Referer:=20
=
http://localhost/projects/Community/index.cfm?job=3Dpmain&un=3DBobbo&=
amp;uname=3Dbobbo&pword=3Dmoo&login_action=3DLogin<BR>Query=20
String: job=3Dpsecond=20
<P></P></TD></TR></TBODY></TABLE></P>
<P>any clue on what I can do to fix this?</P></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,<BR>Tony Hicks<BR>Professionally =
Designed=20
Websites<BR>���� <A=20
href=3D"http://www.righteousdesigns.com">http://www.righteousdesigns.com<=
/A><BR>ICQ:=20
5874143 AIM: Webmigit Y!: Webmigit<BR>���� <A=20
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A><BR>Tir=
ed of=20
your web host?<BR>���� <A=20
href=3D"http://www.nextmill.net">http://www.nextmill.net</A><BR>Need a =
Domain?=20
Don't have a credit card?<BR>���� <A=20
href=3D"http://www.domainsbycheck.com">http://www.domainsbycheck.com</A><=
BR>Got=20
your Free Online Business Card Yet?<BR>���� Here's =
mine: <A=20
href=3D"http://thecardfile.com/webmigit.htm">http://thecardfile.com/webmi=
git.htm</A></FONT></DIV></BODY></HTML>
------=_NextPart_000_002C_01C05EC9.4FF57E20--
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
