Search results for query: *

Hi all, I have used Querystring to display the list for editing: Modify Features.asp <% recstMod.Open "SELECT * from FuncFeat", connectMod Do While Not recstMod.EOF Response.Write(recstMod("FeatName")) & "<a href='ModifyFeatures_verify.asp?FeatID=" & recstMod("FeatID") & "'> Edit</a><br>"...

Hi all, <input type="hidden" name="FeatID" value="<% = rs("FeatID") %> as of the code above, what is the meaning of input type="hidden"? When is it normally used in? How is it different from input type="submit"? Thank you

Hi all, I have posted the problem in the ASP forum before, and was directed here. I have the following script using QueryString: <% Dim connectDel, recstDel Dim FeatureID Set connectDel = Server.CreateObject("ADODB.Connection") connectDel.Open("DRIVER={Microsoft Access...

Hi all, <input type="hidden" name="FeatID" value="<% = rs("FeatID") %> as of the code above, what is the meaning of input type="hidden"? When is it normally used in? How is it different from input type="submit"? Thank you

Hi all, how can I properly align a list shown using QueryString since now its all centre align and there is no spacing between the delete link and "FeatName"? Pls refer to thread333-1196584 for the script that I have posted earlier. Any help is appreciated.

Hi all, I am trying to run a delete script with a list shown and a delete link next to them. The list is shown and the FeatID is to be passed over to another script for request.querystring <% Dim connectDel, recstDel Dim FeatureID Set connectDel = Server.CreateObject("ADODB.Connection")...

Hi all, I was looking through the past thread and found thread333-1019874 regarding checking for duplicate records. I tried checking for duplicate record for one data field using the solutions given and it works. My question is if I have 2 or more data fields to check for duplicate records...

Hello All, I am inserting data into database from user inputs in the textboxes. Right now, my code below is only able to work if all the textboxes are being filled up with data. How can I alos insert the data if only some of the textboxes are being filled up? Any help is appreciated. Thank...

Hi All, I am trying to run an ASP script in deleting recods from database using with checkboxes and the following error message is seen: ----------------------------------------------------------- Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft...

Dear All, Just wanted to know what is <% Option Explicit %> meant for in a ASP script?

Hello, I have a ASP script for insertion of form contents into the database. This is the link to the script that I have posted before in the forum -> http://www.tek-tips.com/viewthread.cfm?qid=1190366&page=1 Now I need to vadilate whether the data that users have entered have already exist in...

Hi all, I have a script that let users perform a search on the data entered and then display data in a table from the database records. Is there a sample script which I can have a submit button for the individual rows to either update or delete records from the database?

Hi All, I have the following script: <% Dim connectAdd Dim recstAdd Dim SQL Dim strProjID1, strProjID2, strProjID3, strProjID4, strProjID5 Dim strFeature1, strFeature2, strFeature3, strFeature4, strFeature5 %> <% Set connectAdd = Server.CreateObject("ADODB.Connection")...

Good day to all, I have a number tables in a database and primary keys are needed for the tables. If I assign Datatype "AutoNumber" for the primary keys for each table, will they be unique? The primary keys are also link up as foreign keys for other tables. I have posted this question before...

Good day to all, After users enter data into textboxes and the data are captured into the database as new records in a table, is there any way to auto generate a primary key in the database from ASP scripts? Note: Primary key is not entered by users but have to be auto generated. Must the...

Good day to all, My asp script requires users to enter data in textboxes and capture them into the database as new records. Does anyone know of any sample ASP scripts or tutorials? Thanks

Good day to all, I have write a inner query in Access database and it is able to produce results. I have 2 tables, Proj and Functional Features. The query is: SELECT Proj.ProjID, Proj.ProjName, [Functional Feature].FeatID FROM Proj INNER JOIN [Functional Feature] ON Proj.ProjID = [Functional...

Good day to all, I have try running the database search asp script below: http://www.asp101.com/samples/db_search.asp by amending the sql statements in the script to run the database that I have created. The problem is that the script runs but no data is displayed that means only the column...

I am currently creating a website with MS Access database to store the data. Anyone can help in the following? 1) How to link MS Access database with frontpage? 2) How can I retrieve the data from the database to be displayed? 3) How can I capture the data from the user input to be stored in...