I'm building a form select from a record set and then using the selected result to call another record set. This a maybe a dumb problem but it has me stumped. The first record always has a comma after it, theres no comma in the database and no comma in the code. Can someone tell where this comma is coming from? Code:
View Repliesi have a form list box, which displays dynamicly. what i what to do is set the selected value where the O_R_ID = session("r_id") Code:
View Replies View RelatedI nwant to pull out the description form the table orders where the first letter is A. I dont have any script tried, because I dont have a clue, I was told it's simple to do though.
strquery = SELECT description FROM orders WHERE ...?
does exist any command to get random row from target table in target database and then use this row ?
View Replies View RelatedI'm trying to do a select * from myTable Where blah blah blah, but am getting back the following error message.
Error Type:
ADODB.Connection (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
This is the code i'm using Code:
I am trying to retrieve option values using Request.Form as you do for textboxes! The textboxes work fine... but I can't get it done for select options.
View Replies View RelatedI have a form which inputs info into a database. However what I would like is to populate a select box directly from the dbase. When the form is entered the field is updated along with all the other info.
I have enclosed two of my pages - I think I'm nearly there.
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 RelatedI am trying to create a form where you may have more than one person
at a meeting, but want to have them be related to the same meeting.
I have a mulitple select text area and if you select more than one,
all the records are being added to the same row. so if I picked the
following three people:
(Person ID/Desc)
1 - mickey mouse
2 - donald duck
3 - goofy
The row in the data base would look like this:
(Meeting ID/ Person ID)
1 - 1,2,3
But I would like to do this:
(Meeting ID/ Person ID)
1 - 1
1 - 2
1 - 3
I hope this makes sense, if it does does anyone have a suggest on how to best do this?
I have a form (which is multipart/form-data) it has a file field and a select. When i submit this form i can get the file but i can't get the value of the select? any ideas?
View Replies View RelatedIs this do-able with ASP / VBscript?
-- I have a database with user records (name, photo, etc. etc.)
I want to use asp to generate (on the homepage) a series of 4 randomly selected 'user records' from the database -- say just the headshot photo or name from the database.
In addition to the recordset being randomly generated (i.e. our of about 50 records, only records 4, 18, 23 and 26 are displayed) I need to MAKE SURE they are not duplicated (i.e. out of the 50 records, records 4, 18, 23 and 23 -- where the last two are duplicates).
Is there a way I can pull this off and how do I go about it exactly?
I have created a query and everytime I try to run it I get this error:
Microsoft JET Database Engine error '80004005'
Record is deleted.
/vsadmin/inc/incsearch.asp, line 162
This is the query: Code:
I have downloaded and installed an ASP Calendar offered for free by Manohar Kamath from his website. I've modified it to accept two new fields (sStart_Time & sEnd_Time). I want to be able to have drop down selections for the time entry, but do not know how to accomplish this.
Please take a look and tell me if this can be done using the <% =Server.HTMLEncode(sStart_Time) %>"> value for this piece or if there is some other way to accomplish this, please let me know.
If I leave it as the following, it works OK, but I want to make it easier for people who are adding to the database: Code:
Is there a way to retrieve the DESCRIPTION in the following code from within the process.asp page without adding additional fields to the form?
<form name="myForm" method="post" action="process.asp">
<select name="Options">
<option value="1">DESCRIPTION</option>
</select>
</form>
What I want to do I select one database and the set the Rs1, rs2 etc.. like in Vb6 I would set DB then:
Set rs1 = db1.OpenRecordSet("Table1")
Set rs2 = db1.OpenRecordSet("Table2")
etc...
However how do I do this in asp3? Code:
I am working on a site with MS Access and ASP that needs to have data selected from a listbox, populate several span fields. I can do it with JavaScript but the array data is hard coded, I want the data brought in dynamically from an Access database. Here is my JavaScript code:
View Replies View Relatedmy form contains two text fields(name, address) and two file field control where user can insert image(photo1 and photo2), i want to insert this data in to ms access when the user submits the form?
this is my code for insert text fields to access data base.but i have no idea about the code for image fields. In my access data base i set photo1 and photo2 as herf (binary data). Code:
I am looking for the basic code to open, select and close a mySQL database using asp code. I am experienced in php and have a site using php to access this database but this client would like one page using asp.
View Replies View RelatedI've got a problem i would like you to help me out with. My company has got a client who sells meat and my senior tech lead has customized the cart to fit their needs and have created a despatch table with a "simple asp form" that allows them to scan their products in with a wi-fi scanner. Code:
View Replies View Relatedi'm new here and i'd like to ask if there's someone who knows how to compare date() function and date from database with date/time type inside select statement so i don't have to do if..then..else
View Replies View RelatedWhat I need to do is to create a form of a dynamic size, and then save
everything from the form in a database. The number of forms depends on
a number from the database which I know how to get. I need to have a
comment and a number, for example if the number from queried from the
database is 2, then I need 2 forms, and it would be something like so:
Comment: Something
Number: 4
Comment: SomethingElse
Number: 6
When the user clicks the submit button, this would be saved in a
database in a table, in a new row. I have the database created and
inserting works very good when inserting just one row, but I need to
insert more then one row at a time, so it would be something like
this: Code:
Does anyone know where I can find a great tutorial that will show me how to take information filled out in a form on a web site that will go directly to an Access database?
View Replies View RelatedHave an asp form created and I need to assign a unique id number to each submission. Can this be done w/o a db?
View Replies View RelatedI have created a nice form that i want on my site for users to fill in detail. But i was wondering if anyone knew any good tutorials on how i can get this info sent to my database?
View Replies View Relatedi have been trying to get info from a form into a database on the server for months, i have one form page and one asp page that should send the data to the database on server heres is my code for both pages. here is the form page:
<form action="deantest.asp" method="POST">
<input type="text" name= "name" ><BR>
<input type="Submit" value="Submit">
</form>
and here is the asp page with the code that i use to put the form data into the data base.
<%dim strformfieldvalues
strformfieldvalues =request.Form("name")
response.Write ("your name is ") & strformfieldvalues%>
I have a form that I want to auto fill in with database data. When the customer number is typed into a textbox and a button in clicked, the database will be queryed and pull back that record.
Once pulled from the database I would like the form text boxes to automatically fill in with the data brought back. Can this be done? If so, can someone show me a small example of the easiest way to do this?
i have a form with fields that contain data from a db. the fields can then be edited, and on the click of the "submit" button, the updated information is returned to the database, replacing the old. a bonus would be arrow buttons allowing navigation from one record to the next, with the information populating the form each time. i'm having a hard time with this.
View Replies View RelatedI am trying to have a form that has multiple records on it and the user can check a box on which ones to add to the database. I created the form but cannot get the fields to enter into the database.
View Replies View RelatedI have the following line of code that is part of a form that displays a record from a database;
<textarea name="name" cols="60" rows="20" value="<% =rscms_example("body") %>" </textarea>
Could you please tell me where I am going wrong on it? I know its probably very simple, but I am terrible at forms anyway.
I need to validate an item number from a form field against a MS SQL database
I am using a 2 page process to print barcodes from an entered item number on page 1 and need to only use valid item numbers from the database. If they enter a wrong number I want to give them a page telling them of the error.
I have 32 fields on page 1 to enter 32 items.(one for every label on the second page that contains the barcodes. Here is the connection to the database that I am using for the barcode.(Column IMLITM contains the item numbers) Code:
I currently have a web page that pulls in job vacancies from a search form all written in asp and the database is in access. I will be placing an extra field which will say "apply now" and on selecting this you will be taken to a new page where you can fill in your details and email them to the employer.
My problem is I need to know how to get a field in the form that will automatically fill in the title of the vacancy being applied for from the database.
How can I specify formatting restrictions for special fields like Postal Code
(format X1X 2C2) or date input field MM/DD/YYYY? I have Acces DB with these specs, but when I used FP2002 Database Interface Wizard, it ignores these. Also I am unable to "edit" any of the records utilizing pages generated by this wizard.
There is an error that it will not accept empty fields. I have no problem adding data (even if some fields are empty) or deleting records.
I have a an issue that I would love to solve. The below code adds 111111111111111111 to the field when I want it to sum the amount which in this case totals 18 and then add that total (18) to the field! Code:
View Replies View Related