I am trying to search for clients contained within a database using multiple search criteria that the user is able to select using a front end form.
The user is able to select there criteria by selecting one or more check boxes and the results are thus retrieved based on what the user has selected. The search works fine until you try and select multiple client types Code:
I have a combo box in an ASP page, there are 7 lists total in the combo box, there is another text box on the page and a search button. I want the users to select an item from the combo box and type a keyword and click search.
The combo item and keyword will be used as an criteria to query a SQL database. I'm familiar with SQL connection and running queries but how do I take the criteria and pass on further.
I created controls dynamically.I want to capture the information from those
controls. Code:
In my Access database I have multiple images for some of the records. What is the best way to retrieve and display the multiple images. I am storing the images in a folder and only the path in the DB.
Some of them have just 1 image, some 2, some 3 and so on. I have the record ID # and the image name same, for eg. if the record id is R01 then the image name would be R01.jpg if there is only 1 image otherwise R01a.jpg, R01b.jpg, R01c.jpg etc. Is there any way I can open the folder and check for the name and list the image file names as a link to display the images if the ID name and image name matches.
I am trying to insert the fields into the DB by quering an insert statement in my form
i get the following error on line:
objConn.Execute(strSQL)
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
I have a database with many tables. I have many objects on my form, textboxes, checkboxes etc... I need to populate a second drop down box after selecting the first drop down box with out the user clicking a button, Yes Master I know how to do the JavaScript onchange but every thin I have looked at uses hard coded data in their example. Can you give me a form example using you tutorial DB of multiple DD Boxes.
View Replies View RelatedI'm having problems retrieving all the values from a multiple selection field using the freeaspupload component.
I'm creating an online email app that uses the freeaspupload to add attachement functionality, which means the form encoding type is multipart/form-data. I've done something similar with the persits aspupload component, and had no problems with that, but the freeaspupload version seems to handle <select> fields slightly differently. Code:
I have a difficult technical challenge I'm facing. I need to retrieve multiple values for the very bottom item in the list, 'Federated' (ignore the rest).
The database will query based off the option 'value', however, in this special case I want to perform a retrieval based off of multiple of values. I want to try to use the existing code without reinventing the wheel. Code:
I am submitting data to a database field, and the data is being submitted in the following manner to a table in the database:
5,3,4,4,3,3,4,5,4,5,5
It's all comma delimeted. Now, what I would like to do is have an update page in which a user can update these values. I am trying to place the values in a repeated text box that corresponds with a repeated question.
The questions that I am displaying are in a repeated field and each question has a text box that will hold the value that corresponds to. I would like to be able to bring in each value into a repeated text box. Right now, each repeated text box contains the above information. (5,3,4,4,3,3,4,5,4,5,5). Is this possible?
I'm trying to retrieve information from a field in a database, which contains data, some of which are the same. ex:
let's say the table is called "Person_info" and there are 5 rows of info with a different person's info.
let's say i want to display the info in the fields called "City" but there are duplicates ex:
Toronto
Vancouver
Toronto
New York
Atlanta
I'd like it to display all the cities in there on a web page, but, I don't want it to display the same city twice:
so it'll display this:
Toronto
Vancouver
New York
Atlanta
I just can't get it to work? it keeps displaying duplicates.
I have a search set up on my site to compare between two <select> values and the value in the data base, but not sure if I have the sql statment correct, my search returns all rows from the table, I want specific row that is between one form select and another... ie. below
for this particular example I want to know if the database AD_PRICE field is between <select name=price> and <select name=price1> and if so, return the only those rows, currently all rows are being returned... Code:
I am trying to write a web application that can retrieve information from an access database, store it in a recordset, update it, then update the access database. However, when I try to update the recordset, I get an error (500).
I have checked my field names a million times (so I am pretty sure it isn't a spelling mistake or anything like that), but nothing is working. I included my code so you can take a look at it. Code:
does any one just help me with the an example of retrieving data from access data base?
View Replies View RelatedJust wondering. I am developing a blog. I would like to display the message post on the blog to be limited to, say, 100 words rather than the whole message itself as this will increase the page length.
I would like to know if there is a method to count the words from the record in database and display only 100 hundred words from the actual message..
I am currently working on a document management system for my company's Marketing department. They wish to be able to upload files to the server.
Rather than deal with the many permissions issues we have had in the past with saving and deleting these files to the server's file system, this time we are trying to use SQL server BLOB fields to store the files.
The premise is simple -- a user clicks on the link and the file is then shown in the browser. The documents are mostly word, Quark, and Adobe Illustrator documents. I was thinking the code would go something like this: Code:
I have sucessfully installed IIS 5.1 on XP Pro, and have validated a couple of test .asp pages.
When I try to connect to Access through Front Page, i get the following error:
The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.
I am using a Replace function to replace single quotes with double when
submitting a text field in the database i.e. Replace (q, "'", "' ' ")
which works fine. When I retrieve the field from the database which has
apostrophe I am getting 'Object expected' error message. Is there a
way to fix this?
I have about 26 checkboxes that place all of my contacts into categories so in my database for contacts i have a field called categories that contains all of the categeories that each contact belongs to seperated by a ",". 1,5,17 etc.
I need help getting these values out of the database so that when I user select category 17 they get all of the contacts that containg the 17 in their respective categories field.
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?
I want to seach though the drives i.e c or d drives and find for the folders and subfolders and even the files and by that order only it should be inserted into the database.I am using MSACCESS database.
View Replies View Relatedi need to pull the following info from my database and display it from the most to the least. User can choose between lets say 10 options. Now i want to generate a page which displays the order for the option most chosen to the option least chosen. Does that make any sense?
View Replies View RelatedI am trying to setup a form in Dreamweaver where I have a list box (Car Batteries, Antifreeze, Paint, etc.)
How do I setup the page up so that when an item is selected and they hit the submit button it will send them to another page returns just the information from that item on the database and not the entire database?
How to perform multiple search using asp in website, the search from local adn remote database.
the local search is working properly, but the remote search stil kinda stuck with it...
my local search script(work well):
dim Connection
set Connection = server.createobject("ADODB.Connection")
Connection.open "Provider=SQLOLEDB;DATA SOURCE=PROTOS;UID=smc;PWD=project;DATABASE=Virtual-Observatory"
how to attach the remote database search for the same website??
i need to make some choices in my search code by adding 1 drop-down box or more like that
<SELECT size=1 name="items">
<OPTION selected value="all" >all</OPTION>
<OPTION value="1" >item 1</OPTION>
<OPTION value="2" >item 2</OPTION>
<OPTION value="3" >item3</OPTION>
<OPTION value="4" >item 4</OPTION>
</SELECT>
so my search string will be
select * from table where rs("itemID") = '"&items&"'
and my quiz is if i want 2 make the drop-down box (items) = all i mean i want the sql statment sellects all of the names what should b the value of the all option ?
note im using 3 or 4 drop-down box and i may nedd the value of some of them to b all and the othere takes any value.
It all seems to work well, but takes a large amount of time for the entire page to load, I guess due to the amount of records that get displayed, or maybe its the repeat region. So, Is there anything I can do in my asp code to speed these things up. Code:
View Replies View Relatedi have a form (22 different criteria although I'm only showing 3) and want to be able to enter criteria into and have it search the database. Code:
View Replies View RelatedI want to do is search through a database based on what was selected on a form.It will be based on state, county, and category.Out of the search I just want one field out of the database, the email field. Now, at first I had one table to mess with so I was using this:
strSQL = "SELECT DISTINCT EMail FROM Info WHERE Category='" & category &"' AND State='" & state &"' AND County='" & county &"'"
the way the database is going to be set up now what I need to do is search through one table that will have all the states, counties, category, and UserID fields.Then it has the other table that will have a UserID field and an email field.So I guess it needs to go through the first table and depending on what state, cat, county were selected it will take that UserID and match it to the UserID in the email table and then pull the emails that match UserID.UserID? Would this use JOIN? UNION? How would this be done, to take the form info and search the one table and then depending on what userid matches the state, county, and category in that table it matches that userid to the userid in the email table and pulls the emails from the email field.
i have a simple search page which i want to search mutiple tables with different layouts so i can return the search results in one recordset. how owuld i do this?
View Replies View RelatedI am searching for a specific record based on different criteria:
First Name, Middle Name, Last Name, City, State, Zip Code, File Number
I am using sql server to store all the information.
how to search multiple fields in an access database?Basically I want the code to search an entire table, field irrelevant.While I'm at it, does anyone know how to make the same search not care about word order or placement?
Such as:
Search string: "John went to the store"
returns the same results as
Search string: "The store went to John"
Just thought I would throw these out there and see what direction anyone can lead me.
I have a small form which searches a SQL DB on several fields - ie.
WHERE Field1 = xxx AND Field2 = xxx AND Field3 = xxx
How can I do this so that if one search criteria is left blank, it ignores it instead of trying to match it in the DB?
I am trying to make a search page. Once a serach word or words is put in I need it to serach multiple product tables and output the description of any prioduct if the search word is present in the description.
However, If i put in 2 keywords like "paper sticker" I get no results. How do you search multiple keywords? Code:
I have a form on one page where someone selects a bunch of options and details about a specific category. Then on the next page they fill out a form with contact information, name, address, email, etc.
Well what I want to know is when they click Submit on that contact form is there a way to have it so it goes through and searches the database for any that match the state and county(which they will select from a )??
So what I basically want right now is for the first form to be filled out, then the second form to be filled out, then when they are submitted it will go through the database and select everyone in there with that state and county, then on the next page display the results of both forms AND the matches in the db(obviously whatever fields I want it to display).
I already have both forms(basic html), I already have the dynamic dropdown for state and county(classic asp), what Im wondering is how do I put that dynamic dropdown in the contact form and then when submitted it will go through and search the db based on what was selected there. Would this be some sort of onClick for the submit button tellin it to search the db based on the dropdown or how would I get started on something like this?
There will be other information on the dropdown like name address email so one problem I was wondering about was my dropdown menu. When you select the state it refreshes the page and then loads the counties, so wouldnt that erase anything that was filled out on the form?
I could make it so they actually type the name of their state and county but that causes problems too because if they mispell either then it wont return any results.