ASP Input Help

[roaml]

Hello,

I am so new to ASP. Can someone show me how to connect to a SQL Server 2000 database and input data.

The following code is used to update a SQL table, but I need to input into a SQL table.

<%
msql = &quot;SELECT * FROM WO_Table where wo_number=&quot; & Request.QueryString(&quot;RecID&quot
Set RS = DataConn.Execute(msql)
%>
Dataconn.Open &quot;Data Source=prodserver;Provider=SQLOLEDB; Initial Catalog=wodb;User ID=woproj;Password=projwo&quot;

DataConn.Execute(&quot;UPDATE WO_Table SET WO_Table.status='&quot; & Request.Form(&quot;status&quot & &quot;' WHERE WO_Table.wo_number=&quot; & session(&quot;wo_number&quot &&quot;;&quot

 

[onpnt]

sounds like you need a SQL tutorial more then a SQL Server turorial
try

http://www.w3schools.com/sql/default.asp

otheriwse

http://www.developersites.com/directory/i174r1392p1.asp

http://www.refdev.com/tutorials/ASP/Server/SQL_Server/

http://www.princeton.edu/~rcurtis/ultradev/tutorial9.html

http://www.tutorialfind.com/tutorials/microsoft/sqlserver/

http://www.abusinessresource.com/Business_Resources/Internet-Based/Technical/Web_Development/ASP/

the web is full of is stuff..


_____________________________________________________________________
_{Where have all my friends gone to????}

http://www.onpntwebdesigns.com

 

[roaml]

Hi,

I know how to do a SQL insert into for ColdFusion, is it the same format? (see below)

INSERT INTO WO_Table(one, two, three)
VALUES('#one#', '#two#', '#three#')

Thanks.

 

[Bullschmidt]

Also the database examples at

http://www.asp101.com/samples

are good.

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer

http://www.Bullschmidt.com

ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...

 

[onpnt]

SQL is a very standardized language. There are slight differences in database syntax for parameters, but other then that it's a standard that doesn't change from platform to platform.

_____________________________________________________________________
_{Where have all my friends gone to????}

http://www.onpntwebdesigns.com