SQL Query On Form Data
I need to select the data where the data ID is equal to the variable supplied in the submitted form. Below is the line of code I used for the radio select and the code to do the SQL search on it. I get the following error using this code:
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/MyWeb/CheckIn.asp, line 93
The items are listed by ID 1-X.
<input type=""radio"" name=""CheckIn"" value=x.value>Check In<br>
Dim junk
junk=request.form("CheckIn")
'If Session("UserType") = "User" Or Session("UserType") = "Admin" Then
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db1.mdb")
Set rs=Server.CreateObject("ADODB.recordset")
'in below, WHERE id = Request.Form("CheckIn")
SQL = "SELECT * FROM CompsIn WHERE ID = junk"
rs.OPEN SQL, Conn, 3, 3
rs.OPEN SQL, Conn, 3, 3 = Line 93
View Replies
ADVERTISEMENT
i try to get data form access with asp. The select contains 2 Subselects. If i set this SQl statement in Access it works. But if i set this in ASP it doesn't. Why??? There is no error. It's completly the same statement.
View Replies
View Related
I'm trying to pass a piece of data i get from a query using a different form's passed values. This is how I get the data into the new form and how I try to pass it to the next asp page query.
<td valign=TOP width="168"><form action="HouseDetail.asp" method="post" name="MLS" id="MLS"><input name="MLS" type="hidden" value='<%=oRs("ML_Number")%>'><input name="Submit2" type="submit" value="Get Details"/></form></td>
The value='<%=oRS(ML_Number")%>' generates a real value like '2403943' - and the field I'm trying to use this value in the qry is expecting a number. But even passing the number without the single ' at both ends generates the same error message. Code:
View Replies
View Related
I have a form that has the option to upload a file at the bottom. If you select a file it works fine but if you leave file selection blank the forms bombs. This is not how I want it to work. On the form you need to use ENCTYPE="multipart/form-data" in the form tag.
On the processing page I need to use Set to assign a variable to the form data. I tried using IF on the variable assigned to the file path but it bombs out telling me "This function is not supported". Is there any other way I can check to see if curQes has a value assigned to it?
View Replies
View Related
I have some ASP server-side code that works perfectly when the client is running on Windows (IE, Netscape, Firefox, etc.) but doesn't work at all when the client is running on Macintosh (IE, Omniweb, Safari, etc.) This is the client-side Javascript code:
View Replies
View Related
I am trying to use a query to filter SQL Server 2000 records by a date
value.
Here is relevant columns in my database table (tblContent):
title [nvarchar]
starting [smalldatetime]
.... and here is my query:
Query = "SELECT title FROM tblContent WHERE starting = '" & date & "'"
I've done exactly this query on numberous occassions in the past with no
problems at all but this time I get the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of char data
type to smalldatetime data type resulted in an out-of-range smalldatetime
value.
What on earth is going on? I'm not using a char data type anywhere! I am
doing all the initial development locally and I have just installed XP
Service Pack 2. I realise it's unlikely, but that's the only thing I can
possibly attribute it to. Or am I just missing something obvious?
View Replies
View Related
I have 2 tables Table_A and Table_B are linked together by TaID
Table_A
TaID - autonumber
Name
Address
Table_B
TbID - autonumber
TaID
Comments
here is my asp page
-------------------------
<%@ Language="VBScript" %>
<!-- #include file="connectionstring.asp" -->
<%
'declare variables
DIM ......
'Assign Variables
.......
Set Conn = Server.CreateObject("ADODB.Connection")
'database connection
Conn.provider = provider
Conn.ConnectionString = dbasepath
Conn.Open
'Sql statement to insert the data
sql = "insert into Table_A ( Name, Address) values (...*data from form*...)
' execute it
Conn.Execute(sql)
Response.Write "Data successfully inserted!"
Conn.Close
Set Conn = Nothing
--------------------------------------------
my question is I also need to insert the data to Table_B, but before that, I want to retrieve the Table_A.TaID first.
so if i do "select TaID from Table_A" and execute the sql how do I assign just the LAST record of TaID and assign to temp variable?
Do I allow to do that? if so, where should I put in the code above?
View Replies
View Related
im trying to display a name from a table, by matching up where an assigned_to id = emp_id in another table. Code:
View Replies
View Related
I have this page with photo thumbnails that are clickable. Each photo has corresponding info saved on a database. When the thumbnail is click, im trying to show the data in an asp page called info.asp.
sample:
Photo #1 when clicked goes to: info.asp?no=1
Photo #2 when clicked goes to: info.asp?no=2
so on so forth..
the database fields are:
no
picname
date
details
I only know how to display ALL info from a database.
But i cant figure out how to display SPECIFIC info triggered by a query string. Example. Photo #1 is clicked. I only want the data that corresponds to Photo 1 to be displayed. How can i do this?
View Replies
View Related
I have a series a forms that submit data to different tables in a database. As it stands, when a user completes FORM 1 and clicks the SUBMIT button, the FORM 1 data is submitted (action = form2.asp, method = post) to ASP code at the top of FORM 2 (request.form("form1 field name") etc...), and submitted to the database with SQL code, also at the top of FORM 2(INSERT into...). Hence the submit button on FORM 1 directs the user to FORM 2, and submits the data which is exaclty what I wanted. However, I now need the users to submit multiple sets of data with FORM 1, and direct them to FORM 2 once they have finished using FORM 1. Most importantly, I need to pass a few parameters from FORM 1 to FORM 2, and have these parameters submitted to the database.
My main problem is getting a fresh form1 after submiting the same form1, in preparation for anoter set of data using the same form. Basically, the database has 'one to many' relationship tables. Form1 and form2 are both populating the 'many' tables, so that each form needs to be filled-in several times while retaining the key field of the 'one' table. At the moment submiting form1 takes me to form2. Is is possible to submit the data to the database, get form1 back again to submit more data, as many times as required, then click another button to load form2 when the user is finished with form1?
Can anyone please give me some pointers? or at least explain the concept of what I need to do. I am a novice and it's taking me a while to get to this stage. Any help will be greatly appreciated.
Is it possible to post FORM1 to itself and insert the data (i.e. place the request.form at the top of FORM 1) If so, how do I direct users to FORM 2 while retaining my parameters?
View Replies
View Related
I have 2 databases, one i write two when i submit the form, that works fine. The other holds contact info. I need for when the Company Initials are typed in(form CSN) that the Pace Administrator info fills automatically(PAName and PAPhone). Code:
View Replies
View Related
How can I get this line to work? I am trying to get the results entered in a form to be part of my query. I am able to get the form results but I get a error stating Syntax error (missing operator) in query expression 'Assignee = Tom Jones'.Below is the line where the error occurs
Session("dbWhere") = "Assignee = " & Request.Form("assignsearch")
View Replies
View Related
I am trying to use form input (like text from a texbox) in a SQL query. So that way a person can enter a value in a textbox and hit a button to check for that value in a database. I have the connection to the database working fine its just passing that form value into the SQL string. I wish the SQL query would work like this:
SQLCommand = "SELECT * FROM dahliaSchedule WHERE scheduleDate= " & txtDateValue
where scheduleDate = (a value from the textbox from the form.)
View Replies
View Related
i have written some asp code on onclick of one button ,purpose is doing those work without submitting main form ,I am not getting working as files are not getting uploaded on web server any syntex error ? do u think this is write way to do so or suggest and modify code:
View Replies
View Related
I want to add two buttons to my page, which direct to and send query information to different result pages.
View Replies
View Related
just manged to get an image retireval search engine working. The ASP script works fine, my query results are filepaths of images.
i structured a query in within asp to obtain images which have similar textual values. It is more of a cosmetic issue. when i get my query results back, my script prints or displays the images from top to bottom. which means i have to scroll vertically up and down the asp page over 10-30 images. Code:
View Replies
View Related
I have the following code that pulls a record based on a form submittal then populates a form with the fields so the record can be updated. My problem is in my query line more than likely in my keyset types and what not. Code:
View Replies
View Related
I am a new programmer seeking a right way for transferring data between forum to forum, as i am creating a site wich have a page keeping 20's of server controls like drop down list and text boxes the value of ddl2 changging on change of ddl1 and displaying its corresponding value in text box and i have 10 rows in this way and i wanna display all selected values of server controls in next page as report.
View Replies
View Related
I am trying to create a form where the user can check a box within a form and the address will fill in automatically from a previous address in the form, without submitting the form.
View Replies
View Related
I need to get some Request value from a Form... but this form is enctype="multipart/form-data" (to upload files) and I if I use the standard syntax Request("nameField") I don't get any value.
View Replies
View Related
I have a form which dynamically loads questions and answers depending on dept.
So the form input type has a value field of the actual answer text which is pulled from the database.
Sometimes the form can be 5 questions, sometimes more and sometimes less. So after the user submits the form, I gather the static input (ie. name, address, email, etc..) but
1. how do I loop to Request.Form for the dynamically generated answers if I dont know how many there may be?
2. How do I then take that data and use it in my Insert statement?
The questions with each answer will automatically generate the imput name field with the qid (question ID) which could be 1-?
View Replies
View Related
i have this page that inserts a form data into database... the problem is that it wouldn't let me insert my content into the database because of syntax problem... more specifically if i have an apostrophe.. it wouldn't let me insert due to the restriction of my code... is there a way to rewrite my code below so that i can insert apostrophe.. right now if there are ' in my content the strSql will screw up...
strSql = "INSERT INTO Events (Title, Author, Content, SDate) VALUES ('"&strTitle&"','"&strAuthor&"','"&strContent&"','"&strDate&"')"
View Replies
View Related
Does anyone know of anything or any issues that may cause HTML form box (shopping cart) to reset or not keep its posted value?
out of approx 2000 users, only 15 are having this issue and the common thing between them is using Mac's (Different browsers but mostly IE5 and Safari. even made one install latest firefox) instead of PCs.
Now I know this goes against everything I ever knew about SERVER SIDE SCRIPTING, but im really reaching for straws.
View Replies
View Related
I am developing a program now. This program has a front page for user to select a project. After the user hit "submit" bttion, he will go to another page which has a top menu.
User can see different part of project information by clicking there. I hope no matter in which order the user click on the items in the top menu, it will show the record based on this project until he select a different project. To realize this function, should I use cookies, or there are better ways to do that? It will be very helpful if someone can provide some sample code here.
View Replies
View Related
I have this code...
If Request.Form("Name") = "" Then
Response.Redirect "error.asp"
End if
If the browser does a GET against this page, sometimes the Response.Redirect doesn't happen. It is as if there is form data being sent on a GET. Has anyone seen this before?
View Replies
View Related
i am working my site using asp html vb javascript and css.
When a user registers on my site i would like them have their own page. I was wondering how would i be able to have a page made automaticaly after that person is registered? I am very new to javascript so....
This is the page after the user is done filling out the form: Code:
View Replies
View Related
I'm trying to retrieve the data off a form (survey.htm) and email the results
back to me using CDO and ASP (survey.asp). I'm confused as to how to
retrieve the form data from survey.htm and send it using survey.asp. Below is
a sample ASP script that I found on ASPFAQ.com and it works fine, but now how
do I grab the info from a form and incorporate it into the emal. Code:
View Replies
View Related
I am using SQL 2000 database and MS Server 2003.
I am pulling in data from a sql table. For some reason, when I include
the following line:
<tr><td><b><%if rs("Street_dir")<> "" then response.write
rs("Street_dir") & " " end if%>
<%=rs("Street_num")%> <%=rs("Street_name")%> <%=rs("Street_suf
fix")%></b></td></tr>
then the following line does not display:
<tr><td><%=rs("remarks")%></td></tr>
The REMARKS data is blank. But, if I remove the upper address line, then
the REMARKS appears. The address is 1111 Main so that does not seem to
be the issue. The address information is VARCHAR fields, 255 characters.
This works fine on another server where my files used to be, but I just
moved to a new server.
View Replies
View Related
Is it possible if i wanna append xml data and upload picture at a same time using the same form?
The problem i'm facing now is, when i add the 'multipart/form-data', i can't append the xml data
I know there's one solution, using 2 FORM but the project i'm doing now is designed to be put them both (file type for upload and textarea for append) together
Besides, i have no idea how to encode or decode the posted data.
View Replies
View Related
This isn't actually causing a problem, but it's odd. I am getting additional data in the data posted by a form on a particular search script I have. I didn't even notice it (since it wasn't causing a problem) but I outputted the form data to screen just out of curiosity I found the following attached to the end of some data: §or=ANY
So for example, one part of the string might be:
&type=Brochure§or=ANY&publication=Evening%20Standard§or=ANY&etc.
It doesn't appear to be affecting anything, but I'm curious as to what that §or=ANY actually is.
View Replies
View Related
I have made a form for users to place an order. When they select the submit button, the user is taken to a form where the user must select to confirm or back to modify.
My problem happens when the user selects the back button (either on the tool bar or on the button provided in the form). I would like the form to remember what the user had just inputted when they go back but currently all entries are blank.
View Replies
View Related
1. A Form which is a drop down menu, posts selected value to the same page.
2. This page connects to a database and depending on the selection from the form. the results are displayed for that selection.
3. This page needs to refresh to pull updated data from the data base.
Heres the problem..
I have the form and page pulling the correct information and displaying it on the page, but when the page does a refresh the value selected from the form is lost and then no results will show.
View Replies
View Related
I want to display multiple records on a form. The user has the choice of editing 1 or more records and then saving the changes. What would be the basic code I need to save the changed records? How would I capture the individual changes?
Right now the only thing that I can get to save is one record per page, not multiple records on a page, because the request.form variables come in in an array format when I put more than one record on a page.
View Replies
View Related