Search results for query: *

it work! Thx!

Hi, I am trying creating a sql query to retrieve the lasted identity # inserted into the table. Here is my code: " pdrQuery = "SELECT MAX(pdrNumber) FROM tblPDR" Set oRsSub2 = oConn.Execute(pdrQuery) pdrNumber = oRsSub2("pdrNumber") Response.Write pdrNumber " The error is: Item cannot...

Hi, I am not too sure if i am in the wrong forum. Basically, I have created a form that gets user information and is stored into a sql database. However prior to storing into the sql table, I want to capture the next available field from the sql table and display it to the user. For example...

Hi, I had created a form that users can submit upon adding information. I want to create an array that will store each forms' values once each form has been completed. So for example: form# field1 field2 1 userEntry1 userEntryOne 2 userEntry2 userEntryTwo...

Ye i realized that: Here is what I did: " <script language="vbscript"> dim validation Function newRequestForm_OnSubmit validation = True Dim strList,packageType, action, distDate, distTime, packageName, CreationTime 'put the list of servers selected into a...

Hi, I am creating this condition where once a user clicks the submit button, the form is checked to see if there are any blank fields, if there are any blank fields, then the user is prompted to refilled the form. However, if there are no blank fields, then the form is successfully submitted...

Cool, thx guys!

Hi, I creating this form where one of the fields shows the current date and time (read only). i want to insert this current date into my SQL database table under a certain column (varchar type). I didnt use any of the date or time types because their size is standard. When I created test...

Thx a lot :)

Ye i tried that. It works. Thx!

Hi, I have create this form. One of the fields ask for users to select a date. What i want is for the user to be able to select a date rather than type on in. So I need to create a calendar popup that will allow the user to select the date. No my question is, what are the steps I have to...

In the database: The servers that are selected as displayed like this: server1/, server2, However, in the database, I want the servers to be displayed in this format: server1, server2 Basically i want the "/" character to be taken out.

Hey, I tried you code. However, when the servers are submitted into the database, it still shows these servers as: server1/, server/. Thx

Hi, As explained in the previous thread, I am create a webpage that displays server info from a database. What servers the user selects will be added to a new table created in the sql database. However, when more than one server is selected, these servernames are inserted into the table as a...

nevermind....i figured it out :)

Hi, I created a connection to a database where i retrieve a list of servers names and display them on a web page form with a checkbox beside each form. I also created another table where the form info will be stored. If a user selects a server and submits the form, the server name that I see...