WannaCry is just the start. Read how Liquid Web is protecting itself and its customers against new threats.
Course Of The Month
1 day, 19 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
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
Originally, this post was published on Monitis Blog, you can check it
here
.
Websites are getting bigger and more complicated by the day. Video, images and custom fonts are all great for showcasing your product or service. But the price to pay in…
- Web Development
- Web Applications
- HTML
- Magento
- Web Development Software
- Monitis, Networking, *Hosting, *Monitoring tool, *Monitoring Software
In this tutorial viewers will learn how to style a corner ribbon overlay for an image using CSS
Create a new class by typing ".Ribbon": Define the class' "display:" as "inline-block": Define its "position:" as "relative": Define its "overflow:" as …
In this tutorial viewers will learn how to embed an audio file in a webpage using HTML5.
Ensure your DOCTYPE declaration is set to HTML5: : The declaration should display
(CODE)
HTML5 is supported by the most recent versions of all major browsers…
Suggested Courses
Course of the Month1 day, 19 hours left to enroll
717 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.