Search results for query: *

Greetings, I've been working with my variables for some time, trying to develop a nice &quot;who's online&quot; page. I've read tutorials, and even tried examples that will output ONE variable, but anything beyond that.. gets interesting. When a user logs in, these variables are set.. <cfset...

I currently have this code in palce to rpelace CRs and LFs and need to replace Quotes: &quot;#chr(13)##chr(10)#&quot;, &quot;<br>&quot;, &quot;all&quot; I tried adding a chr(34) but it doesn't work, and screws up the insert query. Any reason why this wouldn't work...

Okay, I have a million queries using update, insert,and delete, but this one is not working, and I don't know why. I've tried copying in a different form/query to see if i had some weird syntax error, but it doesn't work.. Here goes. <cfif ParameterExists (Delete)> <cfoutput> <cfquery...

I have a simple problem (for once) Assume I have a version number, say 8.2.1010 and I want every reload of a page to update it like this 8.2.1011 8.2.1012 8.2.1013 but never go to 8.3 or so on. My current query: <CFQUERY name=&quot;logplus&quot; datasource=&quot;dbname&quot...

I'm still having trouble with this code! Basically, I'm using CFIF statements to allow a user to upload a photo, and if a photo already exists for that user, delete the existing one and update the database with the new one. Depending on hiw I lay this code out, i get one of two errors. 1...

I have a photo upload processor that looks like this.. <form action=&quot;addphoto.cfm?Save=&quot; enctype=&quot;multipart/form-data&quot; method=&quot;post&quot;> <input type=&quot;file&quot; name=&quot;photo&quot;> <input type=&quot;text&quot; name=&quot;caption&quot; size=&quot;25&quot...

Simply, When a user logs in, I want their &quot;Last Login&quot; to update to the current date. By using previous threads examples, I have he following query <cfset CurrentDate = DateFormat(Now(), &quot;yyyy/mm/dd&quot;)> <cfquery name=&quot;db_insert&quot; datasource=&quot;dbname&quot...

Simple insert causing problems. Insert code is <cfquery name=&quot;db_insert&quot; datasource=&quot;db26401a&quot; dbtype=&quot;ODBC&quot; username=&quot;us26401a&quot; password=&quot;dxm714&quot; dbserver=&quot;localhost&quot; dbname=&quot;db26401a&quot;> INSERT INTO users (id, date, rate...

Ok masters, the last part of this mess. - this follows up to the poetry formattign thread some of you just replied to. After this, 99% of my questions are answered in previous threads. Just hope I can find my $#%@#$! book soon. Now that the poetry is formatted, I have it so that only registered...

I have a site where i want people to be able to upload their own poetry into a database. All I need is for their input to be sved as is, for example This is a poem I am happy Notice how each line has a <br> If thy type this into a form, it all comes out as one long string. I don't trust their...

I am using COld Fusion on Solaris and MySQL. My query is the following: <cfquery name=&quot;modify&quot; datasource=&quot;dbname&quot; dbtype=&quot;ODBC&quot; timeout=&quot;60&quot; username=&quot;username&quot; password=&quot;assword&quot; dbserver=&quot;localhost&quot...

Take this simple little script with 3 fields: id name birthday How can I get it so a user can simply enter their birthday into a text field, And have have MySQL accept it? When I try the following it shows success, but the record is not saved. If I remove the birthday field, everything works...