Unsubcribe
Anyone know how to unsubcribe to this list? Thanks ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Cheap Hosting Needed
Anyone know of any goof CF Hosting companies that charge about 20 to 30 per month. I am with BMI.net right now and they are not very good. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts
Sorry about this Message..
I wouldn't normally send this to the group, but I thought any little thing can help. Please go to: http://rd.yahoo.com/health/raceforthecure/?http://health.yahoo.com/health/ra ceforthecure/ Yahoo will donate $1.00 to the Susan G. Komen Breast Cancer Foundation for anyone who clicks on the link. Spread the word! Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Update Error 2
Before I even had the valid field in my query I was receiving that error. And I also
tried the valid without the ' '. So I am still stumped.
>>> James Maltby <[EMAIL PROTECTED]> 11/09/00 09:38AM >>>
Your error is with #valid# - you've got it setting above (as numeric) while
below you have it inserting as text '#valid#' = remove the '' marks and it
should work.
James
"You're a big man, but you're out of shape. I do this for a living, so
behave"
"Get Carter" 1964
-Original Message-
From: Jeremy Toevs [mailto:[EMAIL PROTECTED]]
Sent: 09 November 2000 16:37
To: CF-Talk
Subject: Update Error
I recieved the following error and can not figure out how to fix it. My
query looks just like the rest of my other ones, but this one just doesn't
seem to work. Can you help me out?
===
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 processing an element with a general identifier of
(CFQUERY), occupying document position (2:1) to (2:28).
===
Here is my query. All fields are in text format. No date formats. Valid is a
yes/no field. I just can't figure out what is wrong.
UPDATE Snowboard_Riders
SET loginname='#loginname#',
password='#password#',
years='#years#',
email='#email#',
from='#from#',
fav_place='#fav_place#',
trick='#trick#',
started='#started#',
ride_exper='#ride_exper#',
valid='#valid#'
WHERE Rider_ID = #Rider_ID#
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Form Validate????
I don't know if this is what you are looking for. >>> "Auction Hard Drive" <[EMAIL PROTECTED]> 11/09/00 09:30AM >>> Is there any way to validate a form field field so it is limited to 45 characters? Thanks, Rich Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Update Error
I recieved the following error and can not figure out how to fix it. My query looks just like the rest of my other ones, but this one just doesn't seem to work. Can you help me out? === 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 processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:28). === Here is my query. All fields are in text format. No date formats. Valid is a yes/no field. I just can't figure out what is wrong. UPDATE Snowboard_Riders SET loginname='#loginname#', password='#password#', years='#years#', email='#email#', from='#from#', fav_place='#fav_place#', trick='#trick#', started='#started#', ride_exper='#ride_exper#', valid='#valid#' WHERE Rider_ID = #Rider_ID# Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Correct Email Format
Is there CF coding to make sure someone fills out the correct format for an email address when they submit a form? Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Bookmarks not working
I have frames set up. a left and a right. My left frames is a list of bookmark links and the right frame is a bunch of texted with the bookmarks. Now when you click on the bookmark link on the left side on the right side it goes right to it. Now this is working for Explorer but not for Netscape. Does anyone know why? Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
cfinsert
I was using the following query:
INSERT INTO Users
(First,Last,Ride,Fav_Place)
VALUES('#First#','#Last#','#Ride#','#Fav_Place#')
But it was giving me an error. None of the fields are numeric, they are all texted
fields. But when I used the following query:
This one worked, but why didn't they other one?
Jeremy
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Divide field in query and output resluts.
Thanks >>> Hong <[EMAIL PROTECTED]> 10/17/00 10:00AM >>> SELECT ROUND( ( TOTAL / HIT ), 1 ) AS output_result -- Hong Wu Senior Web Developer DoubleSpace Jeremy Toevs wrote: > > Is there a way to make it round to the nearest tenth? > > >>> Hong <[EMAIL PROTECTED]> 10/16/00 03:20PM >>> > use SQL math divide operator, > > SELECT ( TOTAL / HIT ) AS output_result > ... > > -- > Hong Wu > Senior Web Developer > DoubleSpace > > Jeremy Toevs wrote: > > > > Can you divide field in a query an output the results. Bacially, I have a TOTAL >field that I want to divid by a HIT field. How would I do that if you can? > > > > Thanks for the help. > > > > Jeremy > > > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > > _ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Divide field in query and output resluts.
Is there a way to make it round to the nearest tenth? >>> Hong <[EMAIL PROTECTED]> 10/16/00 03:20PM >>> use SQL math divide operator, SELECT ( TOTAL / HIT ) AS output_result ... -- Hong Wu Senior Web Developer DoubleSpace Jeremy Toevs wrote: > > Can you divide field in a query an output the results. Bacially, I have a TOTAL >field that I want to divid by a HIT field. How would I do that if you can? > > Thanks for the help. > > Jeremy > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Divide field in query and output resluts.
Can you divide field in a query an output the results. Bacially, I have a TOTAL field that I want to divid by a HIT field. How would I do that if you can? Thanks for the help. Jeremy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Message Board
Dennis, Thanks for the help. That looks great. Can you go ahead and send me the code. Jeremy >>> "DSJ" <[EMAIL PROTECTED]> 10/10/00 03:37PM >>> Hey Jeremy, Take a look at the message board up on my site at http://www.thebrewhut.com. If that's fine, I'll send the code to you for free. That's just the good 'ol simple forum sample app that they use to ship with CF 3.x, which they no longer do. Let me know. Thanks! Dennis > -Original Message- > From: Jeremy Toevs [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 10, 2000 4:23 PM > To: CF-Talk > Subject: Re: Message Board > > > I'd like to take a look at that too. > > >>> Jeffrey Cohen <[EMAIL PROTECTED]> 10/10/00 02:55PM >>> > > --3BC8FB7BAA90D0D7E625E1E0 > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > Well, I don't need it yesterday, but sooner, better. Ya > know...s If you would be so kind as to keep me informed I'd > liek to take a look at it. > > Thanks, > > Jeffrey Cohen > ImageWorks > > Christopher S Martin wrote: > > > Its probably not to helpful right now, but I'm working on a > version of faq o > > matic in ColdFusion. BUt nthis isnt really helpful if you need > something, > > say, yesterday. > > Chris Martin > > > > - Original Message - > > From: "Jeffrey Cohen" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Tuesday, October 10, 2000 14:43 > > Subject: Message Board > > > > > Does any one know of a Cold fusion message board??? I need something > > > simple, without a lot of bells and whistlesjust the usual...topic, > > > info, etc... > > > > > > I don't have a large budget, so a low cost solution or shareware (and > > > free always works too, ) would be helpful. > > > > > > Thanks, > > > > > > Jeffrey Cohen > > > ImageWork > > > > > > > -- > > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > > To Unsubscribe visit > > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > > send a message to [EMAIL PROTECTED] with > 'unsubscribe' in > > the body. > > > > > > > > -- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf > _talk or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. > > --3BC8FB7BAA90D0D7E625E1E0 > Content-Type: text/html; charset=us-ascii > Content-Transfer-Encoding: 7bit > > > > Well, I don't need it yesterday, but sooner, better. Ya know...s If > you would be so kind as to keep me informed I'd liek to take a look at > it. > Thanks, > Jeffrey Cohen > ImageWorks > Christopher S Martin wrote: > Its probably not to helpful right now, but > I'm working > on a version of faq o > matic in ColdFusion. BUt nthis isnt really helpful if you need > something, > say, yesterday. > Chris Martin > - Original Message - > From: "Jeffrey Cohen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, October 10, 2000 14:43 > Subject: Message Board > > Does any one know of a Cold fusion message board??? I need something > > simple, without a lot of bells and whistlesjust the > usual...topic, > > info, etc... > > > > I don't have a large budget, so a low cost solution or shareware > (and > > free always works too, ) would be helpful. > > > > Thanks, > > > > Jeffrey Cohen > > ImageWork > > > > > -- > > > Archives: href="http://www.mail-archive.com/cf-talk@houseoffusion.com/">http > ://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li > sts/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&; > amp;body=lists/cf_talk > or > send a message to [EMAIL PROTECTED] with 'unsubscribe' > in > the body. > > > --
Re: Message Board
I'd like to take a look at that too. >>> Jeffrey Cohen <[EMAIL PROTECTED]> 10/10/00 02:55PM >>> --3BC8FB7BAA90D0D7E625E1E0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Well, I don't need it yesterday, but sooner, better. Ya know...s If you would be so kind as to keep me informed I'd liek to take a look at it. Thanks, Jeffrey Cohen ImageWorks Christopher S Martin wrote: > Its probably not to helpful right now, but I'm working on a version of faq o > matic in ColdFusion. BUt nthis isnt really helpful if you need something, > say, yesterday. > Chris Martin > > - Original Message - > From: "Jeffrey Cohen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, October 10, 2000 14:43 > Subject: Message Board > > > Does any one know of a Cold fusion message board??? I need something > > simple, without a lot of bells and whistlesjust the usual...topic, > > info, etc... > > > > I don't have a large budget, so a low cost solution or shareware (and > > free always works too, ) would be helpful. > > > > Thanks, > > > > Jeffrey Cohen > > ImageWork > > > > -- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --3BC8FB7BAA90D0D7E625E1E0 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Well, I don't need it yesterday, but sooner, better. Ya know...s If you would be so kind as to keep me informed I'd liek to take a look at it. Thanks, Jeffrey Cohen ImageWorks Christopher S Martin wrote: Its probably not to helpful right now, but I'm working on a version of faq o matic in ColdFusion. BUt nthis isnt really helpful if you need something, say, yesterday. Chris Martin - Original Message - From: "Jeffrey Cohen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 10, 2000 14:43 Subject: Message Board > Does any one know of a Cold fusion message board??? I need something > simple, without a lot of bells and whistlesjust the usual...topic, > info, etc... > > I don't have a large budget, so a low cost solution or shareware (and > free always works too, ) would be helpful. > > Thanks, > > Jeffrey Cohen > ImageWork > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/">http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/">http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --3BC8FB7BAA90D0D7E625E1E0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Webtrends
It doesn't help to give us example .jpg's when you need login rights to view them. >>> Iztok Polanic <[EMAIL PROTECTED]> 09/28/00 02:05AM >>> Hi! We are using Webtrends Log Analyzer 5.0 But we found out that pur graphs don't look so good. Here are some examples: http://www.btc-city.com/logs/DEFAULT10.jpg http://www.btc-city.com/logs/DEFAULT22.jpg http://www.btc-city.com/logs/DEFAULT23.jpg How can we change sharpnes in Webtrends reports? Bye, Iztok -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Exam
Where do you take an Allaire CF certification exam? >>> "Michael Dinowitz" <[EMAIL PROTECTED]> 09/21/00 10:39AM >>> Broad topics. Error handling, data validation, state management. If this wasn't the last night, I'd give you the study rules that I gave the developers over here at CA. > TO ANYONE WHO HAS TAKEN THE CF EXAM: > > Tonight is the last night I can study for the Allaire CF certification > exam. Is there any area that you recommend I concentrate on tonight? > > THANKS! > > -John- > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Numeric Field
How exactly would I write this query, my table name being FOOD and field being HITS. >>> Robert Hinojosa <[EMAIL PROTECTED]> 09/08/00 12:39PM >>> Try This UPDATE Products SET ProdCount = (ProdCount+1) HTH, Robert -Original Message- From: Jeremy Toevs [mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 12:58 PM To: [EMAIL PROTECTED] Subject: Numeric Field Is there a way to write a query that will add 1 to a numberic field in a database? Meaning everytime the query is ran, it adds 1 to the current number that is in the database. (example: if the database says 3 and I run the query it will then say 4). This may be a dumb question but it doesn't hurt to ask. Thanks Jeremy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01C019CC.8AAEC54A Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Numeric Field Try This UPDATE Products = = = = = = SET ProdCount =3D (ProdCount+1) HTH, Robert -Original Message- From: Jeremy Toevs [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 12:58 PM To: [EMAIL PROTECTED] Subject: Numeric Field Is there a way to write a query that will add 1 to a = numberic field in a database? Meaning everytime the query is ran, it = adds 1 to the current number that is in the database. (example: if the = database says 3 and I run the query it will then say 4). This may be a dumb question but it doesn't hurt to = ask. Thanks Jeremy ---= --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" = TARGET=3D"_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/= To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli= sts/cf_talk" = TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= &body=3Dlists/cf_talk or send a message to = [EMAIL PROTECTED] with 'unsubscribe' in the = body. --_=_NextPart_001_01C019CC.8AAEC54A-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Numeric Field
How exactly would I write this query, my table name being FOOD and field being HITS. >>> Robert Hinojosa <[EMAIL PROTECTED]> 09/08/00 12:39PM >>> Try This UPDATE Products SET ProdCount = (ProdCount+1) HTH, Robert -Original Message- From: Jeremy Toevs [mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 12:58 PM To: [EMAIL PROTECTED] Subject: Numeric Field Is there a way to write a query that will add 1 to a numberic field in a database? Meaning everytime the query is ran, it adds 1 to the current number that is in the database. (example: if the database says 3 and I run the query it will then say 4). This may be a dumb question but it doesn't hurt to ask. Thanks Jeremy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01C019CC.8AAEC54A Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Numeric Field Try This UPDATE Products = = = = = = SET ProdCount =3D (ProdCount+1) HTH, Robert -Original Message- From: Jeremy Toevs [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 12:58 PM To: [EMAIL PROTECTED] Subject: Numeric Field Is there a way to write a query that will add 1 to a = numberic field in a database? Meaning everytime the query is ran, it = adds 1 to the current number that is in the database. (example: if the = database says 3 and I run the query it will then say 4). This may be a dumb question but it doesn't hurt to = ask. Thanks Jeremy ---= --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" = TARGET=3D"_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/= To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli= sts/cf_talk" = TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= &body=3Dlists/cf_talk or send a message to = [EMAIL PROTECTED] with 'unsubscribe' in the = body. --_=_NextPart_001_01C019CC.8AAEC54A-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Numeric Field
Is there a way to write a query that will add 1 to a numberic field in a database? Meaning everytime the query is ran, it adds 1 to the current number that is in the database. (example: if the database says 3 and I run the query it will then say 4). This may be a dumb question but it doesn't hurt to ask. Thanks Jeremy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Can NOT get INSERT QUERY to work for the live of me!
I can not get my insert query to work, I get the following ERROR MESSAGE:
***
Error Diagnostic Information
ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
The error occurred while processing an element with a general identifier of (CFQUERY),
occupying document position (18:1) to (18:44).
Date/Time: 08/31/00 09:24:10
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 95)
***
Everything in the form is spelled correctly and everything in the database
correspondes with the query. So I don't know what is wrong. Here is my CFM page.
--
Your Form Was Successfully Sent
INSERT into Person (First_Name, Last_Name, Address, City, State, Zip, Country,
Phone, Email, Occupation, Registering_For, Birth_Date, Eye_Color, Hair_Color, Height,
Weight, Chest_Size, Neck_Size, Waist_Size, Skin_Tone, Shoe_Size, Experience1, Fashion,
Print, Runway, Glamour, TV, Swimwear, Sportswear, None, Agency1, Agency2,
Additional_Information, Send_Picture)
VALUES ('#Form.First_Name#', '#Form.Last_Name#', '#Form.Address#',
'#Form.City#', '#Form.State#', '#Form.Zip#', '#Form.Country#', '#Form.Phone#',
'#Form.Email#', '#Form.Occupation#', '#Form.Registering_For#', '#Form.Birth_Date#',
'#Form.Eye_Color#', '#Form.Hair_Color#', '#Form.Height#', '#Form.Weight#',
'#Form.Chest_Size#', '#Form.Neck_Size#', '#Form.Waist_Size#', '#Form.Skin_Tone#',
'#Form.Shoe_Size#', '#Form.Experience1#', '#Fashion#', '#Print#', '#Runway#',
'#Glamour#', '#TV#', '#Swimwear#', '#Sportswear#', '#None#', '#Form.Agency1#',
'#Form.Agency2#', '#Form.Additional_Information#', '#Form.Send_Picture#')
select max(Person_ID) as MaxPersonID
from Person
>From #Form.First_Name#:
GENERAL INFORMATION
Person ID: #ID.MaxPersonID#
Name: #Form.First_Name# #Form.Last_Name#
Address: #Form.Address#
City: #Form.City#
State: #Form.State#
Zip: #Form.Zip#
Country: #Form.Country#
Phone: #Form.Phone#
Email: #Form.Email#
Occupation: #Form.Occupation#
Registering For: #Form.Registering_For#
MEASUREMENTS AND STATS
Birth Date: #Form.Birth_Date#
Eye Color: #Form.Eye_Color#
Hair Color: #Form.Hair_Color#
Height: #Form.Height#
Weight: #Form.Weight#
Chest Size: #Form.Chest_Size#
Neck Size: #Form.Neck_Size#
Waist Size: #Form.Waist_Size#
Skin Tone: #Form.Skin_Tone#
Shoe Size: #Form.Shoe_Size#
EXPERIENCE
Level: #Form.Experience1#
TYPES:
Fashion: #Fashion#
Print: #Print#
Runway: #Runway#
Glamour: #Glamour#
TV: #TV#
Swimwear: #Swimwear#
Sportswear: #Sportswear#
None: #None#
Agency: #Form.Agency1#
Agency Name: #Form.Agency2#
Add Info: #Form.Additional_Information#
Sending Pictures: #Form.Send_Picture#
Thank you for submitting your information.
--
Well, I guess I need someones help.
Thanks again,
Jeremy Toevs
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: UserAction.cfm
How would that query look?
>>> Kelly Matthews <[EMAIL PROTECTED]> 08/29/00 08:43AM >>>
What i normally do is FIRST I RUN a QUERY against the database
seeing if the USERNAME that was passed is equal to any username in the
database. Then i do a
and show a message that the username is taken and then a
that does the insert. That way if the query comes back with at least
ONE record you know the user id is taken if it comes back with ZERO
you do the insert.
Kelly
Stay current with what's happening on AirportNet. Subscribe to our
Announcement list today: http://www.airportnet.org/email.htm
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
> -----Original Message-
> From: Jeremy Toevs [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 29, 2000 11:49 AM
> To: <
> Subject: UserAction.cfm
>
> When you have a "No Duplicates" field in the database and a duplicate is
> entered, CF returns somewhat of a weird error message. How do you get it
> to return an error message saying "This UserName is already in use, choose
> another." UserName being the "No Duplicates" field. Here is my action cfm:
>
> *
>
>
> INSERT INTO Users (UserName, RealName, Email)
> VALUES ('#UserName#','#RealName#','#Email#')
>
>
> *
>
> Thanks in advance,
>
> Jeremy
>
> --
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
UserAction.cfm
When you have a "No Duplicates" field in the database and a duplicate is entered, CF
returns somewhat of a weird error message. How do you get it to return an error
message saying "This UserName is already in use, choose another." UserName being the
"No Duplicates" field. Here is my action cfm:
*
INSERT INTO Users (UserName, RealName, Email)
VALUES ('#UserName#','#RealName#','#Email#')
*
Thanks in advance,
Jeremy
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF Query Problem with Session Variables
Hey CF People, I am storing the current users id in a session variable using the following: Now I am trying to write a query that uses that. SELECT User_ID, FullName, Login FROM Users WHERE session.user_ID = #CurrentUser.User_ID# ORDER BY Login Is it possible to use it, or am I just writing it wrong? Thanks in advance! Jeremy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Building the right tables and pages?
Thank you for helping me out with this. I appreciate any help I can get, but like I said, I'm not an expert. So what is this application.cfm and session variables? Jeremy >>> "Kevin Schmidt" <[EMAIL PROTECTED]> 08/10/00 09:53AM >>> Hmmmsounds like you need to be introduced the the application.cfm file and session variables. I have some files that might help...contact me off list. Kevin ----- Original Message - From: "Jeremy Toevs" <[EMAIL PROTECTED]> To: ">" <<[EMAIL PROTECTED]> Sent: Thursday, August 10, 2000 10:16 AM Subject: Building the right tables and pages? Hello, I am currently trying to build a web site using CFM where people can log-on with a username and password into the site and see information that is meant for only them. Basically what the people at Onvia.com have running on your site. On their web site, you enter your email address and password then you are logged in. The page says "Welcome back Jeremy Toevs" and also displays a logout button. All the information that I am set up for is displayed for me. I want to run a site where parents login and can view their kids grades and what not and no other kids grades. I need someones help. I know a little bit about CFM. But not as much as you guys do. I was wondering if you someone could fill me in on how I can set something up similar to what they have running on Onvia.com. I just can't get the tables right and things like that. I notice that when I log on to thier site the page URL is: https://www.onvia.com/usa/my/index.cfm? task=login. The part ...?task=login confuses me. How does it know that it is me logged in. The only way I know how to do it is. ...? loginname=jeremy&password=834kds. I am confused on the pages I need, the coding I need and the tables I need. Basically, I am clueless at this point in my CF writing. What would really help is if someone could set up a few pages: a login page, the page viewed after the login page, and then a page after that. And also an Access Database with the proper tables and email it to me. And I would be able to figure out the rest from their. If you someone could help me out, I would greatly appreciate it. You can contact me @ (503) 570-3157 or e-mail @ [EMAIL PROTECTED] Please lend me a hand. I am building this site to help parents be more involved with their kids school life. It is really important to me. Sorry for the long message. But thank for your time, Jeremy Toevs Office: (503) 570-3157 Fax:(503) 570-5079 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Building the right tables and pages?
Hello, I am currently trying to build a web site using CFM where people can log-on with a username and password into the site and see information that is meant for only them. Basically what the people at Onvia.com have running on your site. On their web site, you enter your email address and password then you are logged in. The page says "Welcome back Jeremy Toevs" and also displays a logout button. All the information that I am set up for is displayed for me. I want to run a site where parents login and can view their kids grades and what not and no other kids grades. I need someones help. I know a little bit about CFM. But not as much as you guys do. I was wondering if you someone could fill me in on how I can set something up similar to what they have running on Onvia.com. I just can't get the tables right and things like that. I notice that when I log on to thier site the page URL is: https://www.onvia.com/usa/my/index.cfm? task=login. The part ...?task=login confuses me. How does it know that it is me logged in. The only way I know how to do it is. ...? loginname=jeremy&password=834kds. I am confused on the pages I need, the coding I need and the tables I need. Basically, I am clueless at this point in my CF writing. What would really help is if someone could set up a few pages: a login page, the page viewed after the login page, and then a page after that. And also an Access Database with the proper tables and email it to me. And I would be able to figure out the rest from their. If you someone could help me out, I would greatly appreciate it. You can contact me @ (503) 570-3157 or e-mail @ [EMAIL PROTECTED] Please lend me a hand. I am building this site to help parents be more involved with their kids school life. It is really important to me. Sorry for the long message. But thank for your time, Jeremy Toevs Office: (503) 570-3157 Fax:(503) 570-5079 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
