Programming Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Other > Programming Help
Reload this Page

What should i change in this script to get it working?

Discuss What should i change in this script to get it working? in the Programming Help forum on ASP Free.
What should i change in this script to get it working? Programming Help forum discussing programming solutions and code assistance related issues. Feel free to ask questions, or to offer your assistance.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old July 9th, 2005, 02:58 PM
Stevis2002 Stevis2002 is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Jul 2005
Posts: 61 Stevis2002 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 12 h 4 m 50 sec
Reputation Power: 4
What should i change in this script to get it working?
line 159----->> strSQL = "UPDATE Results SET " _
& "Name = '" & CStr(Replace(Request.Form("Name"), "'", "''")) & ", " _
& "Street = " & CInt(Replace(Request.Form("Street"), "'", "''")) & ", " _
& "contactinfo_Address2 = '" & CInt(Replace(Request.Form("contactinfo_Address2"), "'", "''")) & ", " _
& "City = " & CInt(Replace(Request.Form("City"), "'", "''")) & ", " _
& "County = " & CInt(Replace(Request.Form("County"), "'", "''")) & ", " _
& "Postcode = " & CInt(Replace(Request.Form("Postcode"), "'", "''")) & ", " _
& "Nationality = " & CInt(Replace(Request.Form("Nationality"), "'", "''")) & ", " _
& "homePhone = " & CInt(Replace(Request.Form("homePhone"), "'", "''")) & ", " _
& "MobilePhone = " & CInt(Replace(Request.Form("MobilePhone"), "'", "''")) & ", " _
& "Email = " & CInt(Replace(Request.Form("Email"), "'", "''")) & ", " _
& "singlestatus = " & CInt(Replace(Request.Form("singlestatus"), "'", "''")) & ", " _
& "Interests = " & CInt(Replace(Request.Form("Interests"), "'", "''")) & ", " _
& "username = " & CInt(Replace(Request.Form("username"), "'", "''")) & ", " _
& "password = " & CInt(Replace(Request.Form("password"), "'", "''")) & ", " _
& "WHERE (ID = " & iRecordID & ")"


Microsoft VBScript runtime error '800a000d'

Type mismatch: 'CInt'

/admin/edit.asp, line 159


Thanks all...Again!!

Steve
Reply With Quote
  #2  
Old July 9th, 2005, 03:23 PM
mehere's Avatar
mehere mehere is offline
Senior Sarcasm Wizardess
Click here for more information.
  
Join Date: Feb 2005
Location: Dreamland
Posts: 12,867 mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)mehere User rank is General 12nd Grade (Above 100000 Reputation Level)  Folding Points: 10976 Folding Title: Novice Folder
Time spent in forums: 4 Months 4 Weeks 15 h 20 m 54 sec
Reputation Power: 1762
It appears that you're using CInt on text fields. For example: street, address2, city, county, etc.
__________________
Come JOIN the party!!!

Quote of the Month:
Retirement: Because you've given so much of yourself to the company that you don't have anything left we can use.

Questions to Ponder:
What do you do when you see an endangered animal eating an endangered plant?

iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
copyright© 2008 sbenj69
Reply With Quote
  #3  
Old July 9th, 2005, 03:27 PM
Stevis2002 Stevis2002 is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Jul 2005
Posts: 61 Stevis2002 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 12 h 4 m 50 sec
Reputation Power: 4
So that should be CStr instead of CInt?

Thanks for reply,
Steve
Reply With Quote
Reply

Viewing: ASP Free Forums > Other > Programming Help > What should i change in this script to get it working?

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway. 
Stay green...Green IT