I have created a database request page (wahooo - new to asp and it works)
and everything is great. Now I'm creating a second page and want to know if
I'm able to make two different queries on one page. I want to be able to
create one query that uses a Request.QueryString from a URL and then use one
of the returned values from that query to create another query on the same
page. I hope that make sense. Here is the database connection code:
I am using ASP/MS ACCESS to see how I can query the same database, via 2 formfields.
{name: - search}Textfield 1: - Search by Category
AND/OR By
{name: - searchT}Textfield 2: - Location
Currently,
strSearchwords = Trim(Request.QueryString("search")); where "search" is the name of Textfield1
Which is fine, but how can I set it so that on Submit, the string from search, and searchT are somehow joined together into one string?
What I have is multiple tables that I want to pull information from and display it on a html page. I want to select a name from a dropdown menu and then it will display the persons results. There are no foreign keys and I don't have access to modify the database so hopefully I can work out a way without needing to.
So I have a various tables say for example Monday, Tuesday, Wednesday etc then they all have fields for example Monday will have mon1, mon2, monUsername and Tuesday will have tue1, tue2, tueUsername. (hope that makes sense!) The MonUsername and TueUsername will always have the same name. Code:
I'm trying to get results from a number of areas via one command string.for example ?location=devon retrieves everything in devon but I've only got a link for the whole south west so I need to send ?location=devon or cornwall or dorset etc. altogether.Is there a way I can do this without changing the asp page or do I have to only search one field at a time.
View Replies View RelatedI am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....
The trouble:
the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).
I could sure use some conceptualization and query help with a Page Watch
System I am building in Access 2000 and Asp.
I need to cycle through databae and generate a compiliation query email that
notifies a person of yacht(s) that have changed on our website:
Key database tables.....
I have an ASP page where I want to display the 3 most recent records within a database using a SQL query. The problem is that my page which output the results is only showing the first most recent record and not the two past ones aswell.
Am I right in thinking that might be related to the 'loop' function? I know that my SQL code is fine as I have previewed the results from the code and they are correct. Code:
I am wondering if it's possible to simulate the Multiple Document Interface
in ASP/ASP.NET webpages? Maybe using DIV layers? I am trying to create the
little document windows in an application, but in a webpage. I need
dragging, overlap, focusing, resizing capabilites. Also must be able to
encapsulate another DIV layer within this DIV layer. Is this possible?
Does anyone know a library (already-made) div/layer MDI windows for
webpages?
I have taken over a website that was done in Frontpage and I am trying to move away from it. I am having problems with page 1 where I have a link that passes a single value to page 2 in the query string.
On page 2 I want to use that value in the query string to produce mulitple record sets. This actually works when using the fpblib.inc. Is there a way of doing this without having to use Frontpage coding.
I have 2 pulldown menus (<SELECT>) on a ASP page. The list of the second pulldown menu should be updated according the data selection of the first one. how to do this ?
View Replies View RelatedIn asp how How can i pass a parameter value with a space in the value like this:
test.asp?catalog=aValue&lineitem=ladies cloths
I get a %20 as a space in the browser window,
My sql query wont work i have data which is from an access database which id like to pull via asp and here is the sql query i have within my asp page.
sqlQuery = "Select * From tblplayers where code=" & player1 & "," & player2 & "," & player3 & "," & player4 & "," & player5 & ","& player6 & "," & player7 & "," & player8 & "," & player9 & "," & player10 & "," & player11 & ";"
But it wont work im not sql guru so cant figure it out
i was wondering how to go about making a multiple page reports. i am really clue less.
View Replies View RelatedIf you are going to be making multiple calls to the same database from a single page, should you connect/close, connect/close, connect/close....or just connect once at the beginning of the page and close at the end?
View Replies View Relatedi'm thinking about making a muti page survey and was looking for some input on the best way to go about it. example
i want 3 questions on the first page, the user answers then hits next the next questions load and so on. what would be the best way of programming this?
i want to submit 30 field(textbox,combo etc.) data into database.if i take all 30 fields on same asp page or form,the page will not look good, so i want to break that into 3 pages,each page will having only 10 fields.when all required fields on first page will be filled by the user then he will click on next button,so he will see next page , i.e. page no. 2,same for page 3.
if he want to come on previous page for editing some info,it should be possible.on 3rd page there is submit button,when he clicks on submit all the info will stored into table. can anyone tell me is it possible using ASP 3.0? if it is possible then tell me how to do this?
Im basically making a site that will have a homepage with links I will add everyday to graphics and movies on my server. When you click the link it will open a new page similiar to the homepage with the graphic/movie in the middle of hte page.
I know there's an easy way to do this so i can just have it call a database or something like that. Basically I want to just have to add a link to the home page describing what it is, then and add the link to the file to the database and have the coding do everything for me. I think this is asp.
Can someone clue me in. All the sites i've built up until now have hundreds of pages all consisting of the same thing and it's such a pain to keep duplicating code. I'm not looking to get too advanced. If I don't have to use an access database, i don't want to.
I want to add two buttons to my page, which direct to and send query information to different result pages.
View Replies View RelatedI have an asp page with links to a frames page that I need to pass query parameters to. I would like to pass the parameters to the page in the top frame.
The target page is call details and is the default page for the top frame. If I send the parameters to the details page it works just fine. How can I submit these to the correct frame while opening the new frames page?
I've been building an ASP app that sits on top of a relational database (MS Access). The problem is that the data from some web forms need to be stored in different tables. Currently I am using multiple SQL Insert statements.
The problem with this approach is that it is possible that several inserts would succeed and then one would fail. This would ruin my database. Is there some way to synchronize the Insert commands or to "flush" the commands at the same time? I need the Insert statements to either all succeed or all fail.
I currently have designed a web page and inserted some ASP modules into it. But, if I insert more than one ASP module I receive an "Internal Server Error". If I delete the second ASP module the page works perfectly. So, my questions is this. Can you only insert one ASP module per web page? Where is the problem. Code:
View Replies View RelatedI m trying to use multiple option menu using redirect function in ASP.
I managed to do a single option but I need to use multiple options can you please advise on how to do this, so both options apear in the same page. for instance, in the code below a user should be able to select uk and also selects between the other options; population, geography from the same page. Code:
to search based on the beginning characters the sql should be
sql="SELECT * FROM Employee Where Emp_Id Like '" & strId & "%'"
Currently, I do the following in my ASP pages when making use of an MS
Access database:
Dim adoCon, rsSet, strSQL
Set AdoCon = server.CreateObject("ADODB.Connection")
Set RsSet = Server.CreateObject("ADODB.RecordSet")
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("MyDB.mdb")
strSQL="SELECT * FROM MyTable;"
rsSet.Open strSQL, adoCon
...do some stuff...
rsSet.Close
adoCon.Close
Set rsSet=Nothing
Set adoCon=Nothing
I have a couple queries stored in the database that I use when in MS Access.
Can I call these queries instead of using a string to specify the SQL
command?
The above seems kind of verbose for making use of a database. Can it be
simplified at all?
We have a master page set up and it is tied to its css file through the standard method in the <head> tag. What I would like to do though is from another page inheriting the master page to add another link to a css file.
That way i can have the sites global file used to make the general apperance consistent, then make the internal content more flexible without destroying the current css file.
Is this a possible task? When i went into the main master page and tried to add a <asp:contentplaceholder id="additionCSS" runat="server" /> tag to the head. When this is done visual studio alerts me saying it doesn't recognize the tag 'asp'. Is there a way around this? We are only just rewriting the site to use master pages now so I'm still figuring it out.
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 am attempting to only show 10 results per page in my results page. I keep on getting the following error. Wrong number of arguments or invalid property assignment: 'MoveFirst'
Does someone know where i am going wrong? Code:
I have a query on a page that displays the results of a recordset. Each row has a check box that has the table ID associated with the row of data.
I am trying to figure out how do I send every row checked to another page and have that page know the ID's that were checked so the next page can query the table for those ID's and fill out a submission form. I know the form fields I can write so it dynamically names the value based on the script, that part is easy, but trying to figure out how to have the script accept multiple ID's so it can go through each and display the results is not.
Now this is simple if I am just sending one ID to the next page, I can just use a "Post" and append a ?id=xxx to the URL and then do a request.querystring for the ID. Where I am confused is trying to send multiple ID = 's to the next page so it reads more then one ID if more then one was checked on the previous page which 99% of the time it will be.
HERE IS MY MAIN QUESTION:
What should I look up to point me in the right direction to create a classic VBScript/ASP code to parse through the ID's that were checked on the previous page and have the next page query each ID for the data?
I can pretty much figure out how if I know what I am looking to do. I was just looking for some sort of direction that I can pursue to understand how do do this task. What is it I am trying to do? IS there a term or set of terms I need to consider looking up to get examples so I can tweak and write it from there?
i am new to asp and web designing, and was wondering how to reload a page so that a different set of images appear, depending on which submit button is pressed. Code:
View Replies View RelatedMy code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
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.