...'Set an active connection to the Connection object using a DSN-less connection
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Survey.mdb")
'Set an active connection to the Connection object using DSN connection
'adoCon.Open "DSN=guestbook"
'Create an ADO...
...'Set an active connection to the Connection object using a DSN-less connection
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Survey.mdb")
'Set an active connection to the Connection object using DSN connection
'adoCon.Open "DSN=guestbook"
'Create an ADO...
Here's a script that will check the null value of your input boxes...just cut and paste the code ( remove the cut below & cut above ) and change the NAME of your input box to the name of the each input box in your form. Put this scripts in the <HEAD> </HEAD> html tags
<SCRIPT...
Here's something that should be easy to answer.
Here's a loop that will print ALL the 'comments' records.....how can I only print the last record ? And if possible how can I only print the last 2 records ?
Do While not rsGuestbook.EOF
Response.Write (rsGuestbook("Comments"))
Loop
First, don't write a cookie that will expire in 2100....if the user likes your site he WILL come back way before 2100...
Try amending the code of your second page to :
<%
Response.Buffer = True
If Request.Cookies("SiteCode")("SiteCode") <> "" Then...
I need to store the value of an INPUT box that might have more than 255 characters into an Access database accessed from my ASP page.
I read somewhere that the maximum characters that can be store in a single recordis 255 ...I even got error messages when trying to store a value of more than 90...
this ASP example uses Windows Script and I don't hink it's installed on the server hosting my page because I get an error message.
Does someone have any other idea how this can be done ?
First :What's the difference between
Request.ServerVariables("REMOTE_ADDR")
AND
Request.ServerVariables("REMOTE_HOST")
They both seem to return the IP of the user connecting to the site.
Second : How do I get the Name Address ( example : modemcable215.51-242-08.mc.videotron.ca ). There's a...
A question from a newbie.
I've heard that if someone finds the path to my .mdb Access database they could simply download the file and read the content. I tried it and it did work! I could password protect it but we all know how much ''protection'' that will give me. What options do I have...
I'm learning ASP and would like to link my ASP pages to a database...I need something VERY simple just to store the weekly sales of my employees ( 5 employees)....Should I go MySQL, SQL, Access, other ??? Which one is the easiest to learn ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.