i am creating a kind of search using dropdown boxes to search the database. I have got two dropdown boxes one called location and one called cuisine i have sorted out some if statement.
so that it works if they select either one or the other and if they select any location or any cuisine but the problem comes when i need them to be able to select a cuisine in a particular location ie on bothe boxes.
i need it if both are selected at the same time then search the database via location and cuisine. can anybody help here is the code for the two files.
I want to search through different strings and replace the ‘0’ with empty value. My problem is I want to search and replace the ‘0’ with empty values until there is a value other then ‘0’.
I've got the following code that sets a session object. set obj = server.createobject("Scripting.Dictionary") set session("testobj") = obj
If I want to remove the session object, do each of the following does the same job? Which one is the best? 1 --> set session("testobj") = null 2 --> set session("testobj") = nothing 3 --> Session.Contents.Remove("testobj")
If I want to check if the session object is not exist, which is the best option? 1 --> if (session("testobj") = null) then ... 2 --> if (session("testobj") = nothing) then ... 3 --> if (isobject(session("testobj"))) then ...
I am trying to update and append to an existing XML file. However I seem to be stuck. I am using ASP as my scripting language.
The form fields has the same value as the KEY attribute so all i have to do is loop through the submiting form for its fields and use the name to update the XML via the keys... Code:
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews headline content
tblDatabank filename description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
I have a database being updated by a text file every ten minutes, so in the code that is why the column names are messed up.
My problem is I get all the sums, and counts all working. What I need to do is at the end of it have a sum for for all the columns returned, i.e. col002, I need all the sums in that column added up for a total at the bottom. The following code works but when I try to do column totals I can't get it to work, Code:
I need to connect to 2 different databases in ASP and execute two different queries. Please let me know how to proceed. I understand that ADODB.Command option can connect to only one database at a time.
Is there a way of using multiple recordsets with the same connection?
My recordset at the moment inserts data into the database, and i want to have a drop down box with data already within the database, as well as the insert recordset, is there a way of doing this?
This is my code, for some reason, when I use this exact code it doesn't update my database, but if I use the next section of code it does. Anybody knows why that when I use two different "Insert" in If Then End If, it doesn't work? Oh and I did try the "If PID = 105 OR 151 Then" alone and it works well. Code:
I have a replace function <%= Replace(arData(0,i), "_", " ")%> that works fine to replace the _ with a space, but I'd also like it to look for, and replace one word with another in the same string (E,G replace the word "Right" with "Wrong"). The code is located in a table that is displaying the results of a database search.
I'm having problems with a) finding out if it's possible to do it this way, and b) what the syntax should be. I've tried all manner of combinations, but no luck. Any ideas?
I need script or a link to a tutorial that will allow me to do the following.
User enters username and password site checks the username and password against database1 if the user entered the correct username and password the page shows records from database2 if the user enterend incorrect username or password then nothing happens.
I am new to this forum and really looking forward to being involved in the community.
i am trying to do Multiple Posting to different Server when User post the Order form. one to windows server second to linux server third to its own server
how to have multiple language asp pages? For example, you have a database driven website that you want customers around the world to use. How do you setup the asp pages so that it is easy to change the text based on where the user is connecting from?
I need to have some dynamically created ASP, with mutliple word documents and PDFs all connected so that it can be printed with a single print command. My two ideas are: having the PDF and DOC files act like images and print entire thing as a web page. -Or- Creating a single PDF file from the concatenation of the asp results and the doc and pdf files.
I am using asp codes to connect to my access database. But i have a query in mind. Will my database still work if more than 1 user is logon to edit the database records?
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 have this search and results system on one page.... I'd like it where the results that come up from the search are editable and can be updated. I can't seem to figure out a working way to update more than one field at a time.anyone have a good piece of code for multiple edits
I have some code I am working on. One function reads a file using fso, then I have multiple functions using the string read from the file. Each function splits the lines up and will return one value. Is there a better way? Is handling this many array which are basically the same going to cause some server distress
We have a Web page that at load time will execute and build: a DHTML Menu/Data Driven, an Iframe with Detail Data, an Iframe to display Progress Information and another iframe with totals information of the previous iframe with Detail Data. Everything works fine except during the initial load. If we click on any place of the page during the above loading schema, the process stops and we end-up with Iframes with incomplete information and empty calculations. We need to refresh and avoid using the mouse and keyboard during the load time to get a decent start.Is anyone familiar with this behavior? Any ideas to solve this issue without disable the mouse?
I'm working on an application that has a worklist of items for users to work on. I'd like to, based on user security, to filter a worklist based on between 1 and 8 items (i.e., location, category, alpha split). That first part is no problem.. the problem is.. how to then allow that user that is (for example) restricted to work 3 locations, to then further filter that worklist to just one location?
Yes.. I can use the ADO filter.. but.. that won't work if you extend the filter beyond one element (i.e., location and category).