Help | Site Map
Connecting Tech Pros Worldwide
Reply
 
LinkBack Thread Tools
  #1  
Old September 16th, 2008, 11:53 AM
Newbie
 
Join Date: Sep 2008
Posts: 3
Default ASP VBScript commands

hello ,
i would really appreciate it if anyone can help me with the meaning of this commands:


1. <form name ="form1" action = "add to database.asp" method

2. %@language= "VBscript"%
<% option explicit %>

3. set connection = server creat object <"ADODB.connection">
set.recordset

4. sconnstring="PROVIDER=microsoft.set.OLEDB.40" & "data source = " & server.mappath <"user.mdb">

5. sconnstring = "PROVIDER = microsoft.set.OLEDB.40" & " data source =" & server .mappath <"user.mdb">
set.recordset = nothing.

6. execute the SQL
connection.execute<SQL>
Reply
  #2  
Old September 16th, 2008, 03:10 PM
shweta123's Avatar
Expert
 
Join Date: Nov 2006
Location: India,Pune
Age: 29
Posts: 657
Default

Hi,

Following is the meaning of the commands you have asked :

1. <form name ="form1" action = "add to database.asp" method
Answer :
The form element creates a form for user input. A form can contain textfields, checkboxes, radio-buttons and more. Forms are used to pass user-data to a specified URL.

Attributes specified with form tag :
i> name : It specifies name of the form.
ii> action attribute: It specifies the URL that defines where to send the data when the submit button is pushed

2. %@language= "VBscript"%
<% option explicit %>
Answer:
@language attribute specifies the language you are using on ASP page.
option explicit specifies that the variables declaration is compulsory.

3. set connection = server creat object <"ADODB.connection">
Answer :
To create a database connection object on the server using the ADO Database connection object


4. sconnstring="PROVIDER=microsoft.set.OLEDB.40" & "data source = " & server.mappath <"user.mdb">

Answer :Above connectionstring is used to open a connection to the database.

Following is the explanation for the connectionstring you have specified :
1> Provider : It specifies type of driver we are using for accessing the database.
2> Data Source :Path of your database file.
3> Server.MapPath: returns the physical path of file to the script.


5. execute the SQL
connection.execute<SQL>
Answer :
execute method is used for executing the sql statement for given database.
Reply
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles