Write database content

Results 1 to 2 of 2

Thread: Write database content

  1. #1
    ifred Guest

    Default Write database content

    I have the following code that provide links to database fields based on thier ID.I need to write the rest of the information in that field (row), how can i do that?? For example,in the field with ID = 1, i need to write the other information in that field (row) like price and ... This is the code i&#039m using <BR><BR>&#039Set a connection <BR>Set cnn = Server.CreateObject ("ADODB.Connection") <BR>cnn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("cost database.mdb") & ";"<BR> <BR><BR>&#039Now we dynamically create an SQL statement based on <BR>&#039the value of our variable with the very long name. <BR><BR>sql = "SELECT id FROM items WHERE id =" & theRecordIDThatYouNeed <BR><BR>Set rst = cnn.Execute (sql) <BR>Response.Write rst(0) <BR> thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Write database content

    sql = "SELECT * FROM items WHERE id =" & theRecordIDThatYouNeed <BR><BR>...<BR><BR>Response.Write rst("your field name")<BR><BR>j

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts