Hi Tony
You use #cgi.HTTP_REFERER#
But bear in mind the following:
http referrer � will only work if the user reached the page by clicking on a
link, if the user reached the page by typing in the url, from a redirection
or bookmark, an email or any non-browser environment this cgi variable will
not exist.
Also although i do not have the full url but most of the Coldfusion
documentation (ie manuals - not the Ben Forta books )is available on line
try searching www.allaire.com
Hope this helps.
-----Original Message-----
From: Tony Hicks [mailto:[EMAIL PROTECTED]]
Sent: 08 December 2000 01:51
To: CF-Server
Subject: Re: Profile Script gone wrong...
Hello Everyone....
First of all I owe a thankyou to Mr. Leavers.
Might I ask somebody how i display the referring url on a page? I don't have
a manual for cold fusion so I rely on tutorials and examples netwide to
teach me....
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
----- Original Message -----
From: "Troy Leaver" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Wednesday, December 06, 2000 1:37 PM
Subject: Re: Profile Script gone wrong...
> 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
