Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
COURSE of the MONTH
9 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
ASP problem, please help me !
Posted on 1998-12-26
Big problem when I try to update an existing field with SQL.
numero = request.querystring("numer
auteur=Request.Form("auteu
news=Request.Form("news")
titre=Request.Form("titre"
heure=Request.Form("heure"
sDate=Request.Form("sDate"
images1=Request.Form("imag
images2=Request.Form("imag
images3=Request.Form("imag
images4=Request.Form("imag
images5=Request.Form("imag
images6=Request.Form("imag
update1 = "UPDATE News SET auteur = "& auteur &", news = '"& news &"' ,titre = '"& titre &"', heure = '"& heure &"', date = '"& sDate &"', images1 = '"& images1 &"', images2 = "& images2 &", images3 = "& images3 &", images4 = "& images4 &", images5 = "& images5 &", images6 = "& images6 &" WHERE numero2 = "& numero &""
I don't know... i declare the variable.... it say me : the content of auteur is a missing operator or somthing like this.....
Please help me !!! 200 POINTS !!!!!!
Nic
numero = request.querystring("numer
auteur=Request.Form("auteu
news=Request.Form("news")
titre=Request.Form("titre"
heure=Request.Form("heure"
sDate=Request.Form("sDate"
images1=Request.Form("imag
images2=Request.Form("imag
images3=Request.Form("imag
images4=Request.Form("imag
images5=Request.Form("imag
images6=Request.Form("imag
update1 = "UPDATE News SET auteur = "& auteur &", news = '"& news &"' ,titre = '"& titre &"', heure = '"& heure &"', date = '"& sDate &"', images1 = '"& images1 &"', images2 = "& images2 &", images3 = "& images3 &", images4 = "& images4 &", images5 = "& images5 &", images6 = "& images6 &" WHERE numero2 = "& numero &""
I don't know... i declare the variable.... it say me : the content of auteur is a missing operator or somthing like this.....
Please help me !!! 200 POINTS !!!!!!
Nic
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
6-
6
-
3
- +2
17 Comments
Make sure that you have a single quote and then a double quote around each variable. It looks like you might not have them. Something like this: "UPDATE News SET auteur = '" & auteur & "', news = '" & news & "', etc.... Only put the "'" around textfields, other fields such as Date/Time and Numbers don't need them.
Are you using any special characters as value for the auteur variable, when you're testing? Like accent aigu or quotes or so.
It's good to run a request.form value thru somekind of a filter before finally committing it to the database. One necessary filter that comes to mind when dealing with text field is the apostrophe to double apostrophes.
Author = Replace(Request.Form("Auth
Another field type that might need conversion is the datetime field.
Normally, if the form field itself already formatted correctly this will not matter, but since we can't really be sure about this, we might as well do a conversion ourself just to be cautious.
A simplest way to convert the date field is just to convert it using VBScript cDate function, althought this might not work all the time depending on the data entered.
PublishDate = cDate(Request.Form("Publis
I did my own conversion routine for datetime field that will generate a SQL friendly datetime string field.
i.e. 11/20/1998 to Nov 11 1998
Datetime input can be a pain in the butt sometimes. I ended up coding an ASP/JavaScript Calendar control component to tackle this problem. So far, it works for me. I don't have to do any validation on the datetime field anymore :)
You can find the component at http://www.developer.com/directories/pages/dir.activeserverpages.components.commercialcomponents.miscellaneous.2.html
Author = Replace(Request.Form("Auth
Another field type that might need conversion is the datetime field.
Normally, if the form field itself already formatted correctly this will not matter, but since we can't really be sure about this, we might as well do a conversion ourself just to be cautious.
A simplest way to convert the date field is just to convert it using VBScript cDate function, althought this might not work all the time depending on the data entered.
PublishDate = cDate(Request.Form("Publis
I did my own conversion routine for datetime field that will generate a SQL friendly datetime string field.
i.e. 11/20/1998 to Nov 11 1998
Datetime input can be a pain in the butt sometimes. I ended up coding an ASP/JavaScript Calendar control component to tackle this problem. So far, it works for me. I don't have to do any validation on the datetime field anymore :)
You can find the component at http://www.developer.com/directories/pages/dir.activeserverpages.components.commercialcomponents.miscellaneous.2.html
nicjak, I am still writing the survey. I will send it to you when complete. You have an email address?
Featured Post
Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
When crafting your “Why Us” page, there are a plethora of pitfalls to avoid. Follow these five tips, and you’ll be well on your way to creating an effective page.
In this tutorial viewers will learn how add a scalable full-width header using CSS3.
Create a new HTML document with an internal stylesheet. Set a tiled background.: Create a new div and name it Header. Position it with position:absolute at the top…
In this Micro Tutorial viewers will learn how to create navigation buttons that change on rollover, using CSS
(Continuation of the CSS Image Sprite tutorial)
Create a parent ID for all the list items - Specify position: absolute and display: block…
Suggested Courses
Course of the Month9 days, 9 hours left to enroll
762 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.