Ask a Question related to ASP, Design and Development.
-
mike #1
adding to db
I bought 3 books and spent weeks trying to add a record to
my database, but haven't figured it out??? I've tried both
sql and addnew method, but to no avail. Below is my sql
method. Any ideas would be highly appreciative.
<% @Language=VBScript %>
<% Option Explicit %>
<% Response.Expires = 0 %>
<%
Dim objConn, objRS, strQ
set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString="DRIVER={Microsoft Access Driver
(*.mdb)};" & _
"DBQ=c:\home\mike\www\data\data.mdb"
objConn.Open
strQ = "INSERT INTO appointments (name) VALUES ('mike')"
objConn.Execute strQ
set objRS = objConn.Execute("SELECT * FROM appointments")
%>
<html>
<body>
<%
objRS.Close : objConn.close
Set objRS = Nothing : set objConn = Nothing
%>
</body>
</html>
mike Guest
-
Adding a .pl to @INC
Hi I am a newcomer to Perl, am trying to run a Perl file which calls a function from another Perl file. But while running it is complaining that... -
Adding OU
Hi How can we add OU to a directory? TIA details..... I have tried using the following code but getting exception error Exception: The... -
DataGrid - Adding labels: and adding data to cells
I am just getting started with flash scripting. My downfall is trying to get the dynamic output to display in flash. I tried using the list... -
Need help adding !!
i am trying to use lingo to add 1 to its value - on mousedown, which is easy enough, but i have for example '00045' and when i add 1 the number then... -
Adding points to a database ( adding / subtrating numeric values)
HI all, I have build a user database that comes with user points for browsing private section of my site. I would like to know what is the... -
Tom B #2 Re: adding to db
I'd use a different connection string.
objConn.ConnectionString="Provider=Microsoft.Jet.O LEDB.4.0;Data
Source=C:\home\mike\www\data\data.mdb;"
see [url]www.connectionstrings.com[/url]
I assume your database has a table called appointments with a field called
name in it.
try
strQ="INSERT INTO appointments([name]) VALUES('mike')"
as I'm sure name is a reserved word
move your "set objRS=" to ....
<html>
<body>
<%
Set objRS=objConn.Execute("SELECT [name] FROM appointments")
Do While not objRS.EOF
Response.Write "<LI>" & objRS.Fields("name").value & "</LI>" &
vbCrLF 'note no [ ] here
objRS.MoveNext
Loop
Set objRS=nothing 'note you don't close the Recordset......because
you didn't open it.
objConn.Close
Set objCOnn=nothing
%>
</body>
</html>
"mike" <gomerpyle13@netzero.net> wrote in message
news:03c101c340cc$d79c5a00$a101280a@phx.gbl...> I bought 3 books and spent weeks trying to add a record to
> my database, but haven't figured it out??? I've tried both
> sql and addnew method, but to no avail. Below is my sql
> method. Any ideas would be highly appreciative.
>
> <% @Language=VBScript %>
> <% Option Explicit %>
> <% Response.Expires = 0 %>
> <%
> Dim objConn, objRS, strQ
> set objConn = Server.CreateObject("ADODB.Connection")
> objConn.ConnectionString="DRIVER={Microsoft Access Driver
> (*.mdb)};" & _
>
> "DBQ=c:\home\mike\www\data\data.mdb"
> objConn.Open
> strQ = "INSERT INTO appointments (name) VALUES ('mike')"
> objConn.Execute strQ
> set objRS = objConn.Execute("SELECT * FROM appointments")
> %>
> <html>
> <body>
> <%
> objRS.Close : objConn.close
> Set objRS = Nothing : set objConn = Nothing
> %>
> </body>
> </html>
Tom B Guest
-
Robb Meade #3 Re: adding to db
"mike" wrote ...
[snip]> I bought 3 books and spent weeks trying to add a record to
> my database, but haven't figured it out??? I've tried both
> sql and addnew method, but to no avail. Below is my sql
> method. Any ideas would be highly appreciative.
Getting any specific errors or is it returning a white page with no text but
yet not adding the data?
more info needed.
Regards
Robb
Robb Meade Guest
-
Bob Barrows #4 Re: adding to db
mike wrote:
[url]http://www.aspfaq.com/show.asp?id=2062[/url] - updatable cursor> Thanks Tom, it was your suggestion to move code to the
> body that led me to find my error of a read only db. I
> don't have it read only, but never-the-less, my code only
> works with a new db. Thanks tremendously.
[url]http://www.aspfaq.com/show.asp?id=2009[/url] - 80004005 errors
Bob Barrows Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
