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>&nbsp;<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
