I am running two queries on a single page and they essentially work, the only problem is that i am unsure exactly how to get one aspect to function properly.
To explain it correctly it will probably be easier to just show you the code, the first query looks like this: 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.
I'm building a page to display a series of records but wanted to filter the results by location and display the resulting records under their own sub-heading.
All the records are in the one db table and there'll be a total of 5 queries.
I'm unsure whether I need to open and close the connection for each query, or whether it's better to open one connection, run all the queries and then close the connection at the end, if so, the resulting code would look like: Code:
How do I pass in more that one variable in the form tag below code: <% Dim CmdPopulatelist Set Conn= Server.CreateObject ("ADODB.Connection") Set CmdPopulatelist = Server.CreateObject("ADODB.Recordset") %> . . <% sql_select= "select * from Patch_Feedback where Patch_name= '"& view_name &" ' and Name_of_user = '" &Name_of_user &"' " %> <% Conn.Open "DSN=Patch;uid=cmadmin;pwd=dci01;database=cm_db" Conn.execute(sql_select) CmdPopulatelist.Open sql_select, Conn %> . . . <form method ="post" action="updateresponseA1.asp?update_ID=<%Response.Write(""& CmdPopulatelist ("Patch_ID") )%> ">
I have code that is looking at the userlogin name and then assigns them to a certain value, thereby allowing them to see certain groups of reports on a website. If I want them to have multiple values, how would I code this? This is what I have so far:
I've a multiple checkboxes and would like to insert those values into the db. How can we insert all those checkboxes’ values into 1 field (DB), we use a stored procedure. This is urgent
how i could put multiple values on to a Query String and get them on the next ASP page. Currently on wy website, i know how to get one, but i am not sure how i am able to get more than one assigned to a specific variable.
how do get ASP to display multiple calls from a database? For example, I can name a variable for a password, then query the database, then call the password variable later in the code and it should display the password from the database.
Code:
strBody = "Here is your login password: " & strPassword
If in the body of this message I want to have a username on the next line, how do you do this in code? I thought you used a &vblt command, but that throws an error.
i've got 7 radiobuttons with the same name, but them values are different. I need to request the checked values and insert in my field on the database, but how can i get do this separated ones?
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?
code: public function fncGetPageContent(intSectionId_In) set rsPageContent = connection.execute("SELECT TOP 1 * FROM sections WHERE section_id = " & intSectionId_In & ";") if not rsPageContent.eof then strSectionCopy = rsPageContent("section_copy") strSectionTitle = rsPageContent("section_title") end if rsPageContent.close set rsPageContent = nothing end function
My question is, how do I call this function and return the two distinct values?
I have a stored procedure that requires one variable to be filled: WHERE ItemNo = @ItemNo Instead of sending 1 value,I'd like to send a bunch of values. I don't mind changing the SP if I new how to approach this. The user would select any number of ItemNo's from a form and submit.
Assume ItemNo's like: B1, B2, B3, etc... The end result would be something like ... WHERE ItemNo = B1 or ItemNo = B5 or ItemNo = B10 ...etc....
I want to build a recordset based on the user's selections. How?
I've looked around the net and searched this message board and haven't been able to find a solution to this problem. An application that I am currently making pushes and pulls data from SQL. One stored procedure is very important and returns many values.
I call this sp many times in my script and wanted to put it in easy to manage function, sub, or whatever works. The problem is that it returns about 10 values that I would need to return from the function back to the standard asp. Code:
I have a form on a web page with a number of radio buttons bound to the same field. Is it possible to set up the form so that users can select more than one radio button to submit multiple values to a field in the way that you can, for example, in a drop down field?
I am using both VBScript and JavaScript functions in the same ASP file. All I need to do is to retrieve some values which are calculated in the VBScript function, to JavaScript. The call to the VBScript function is made through a JavaScript function. Code:
I loop through a recordset to return values that populate a form which the user can then edit and save. However these fields need to be validated first to make sure the data entered is correct. I have a Firstname field that returns 3 records from my recordset which means when I try to validate, I get an error as the page doesn't know which of the 3 to use. I believe I have to do it through an array, but have no clue how as my efforts have failed
I'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:
Normally I use Access database with ASP, and I create queries using the wizard which Access has. Then, I copy and paste the code in the ASP page and create my SQL.
I was wondering if it is easier to call the query directly with its name from Access, or else continue using the old procedure.
I'm trying to build sql queries that will search through my DB. I am currently seperating my queries through multiple indexes in an array depending on whether or not the strings are wrapped in quotations.
I also want Fluffy Teddy Bear (three different LIKE statements)
Say I have 5 fields in a form. I have figured out how to query a database using all 5 fields and display the records that match at least one of the fields.
I'm trying to figure out a way to, if say the user only fills in two fields, to only search the database for matching records based on just the two fields. As I have it now, the database is searched for the two fields they entered as well as three fields of "", which I would rather not have. Is this possible?
I have a DB. With 1 table called "products" and 3 product records. The 2 fields present in the table are called product_name and product_price. The names of the products are Product1, Product2 and Product3. They cost 13, 8 and 24. Which code (SQL and AP) would generate an output similar to this?
<% SQL = "Select * FROM products" (plus some kind of sum function to calculate the total (to be able to display the sum before the various products) of the recordset without having to loop through the recordset first) %>
I never ever thought about this, but recently I made a query in access so I can make a customer mailing list based on relational information and it was so easy to make the query and join tables and assign criterea using access. And I haven't tried or thought about this cause in my own small asp projects I've never used a dbase with queries in it, but after seeing how easy it was, it would save a lot of time from manually writting queries in asp.
So, what I'm asking is if I can use a query from an mdb in asp just like I can access tables?
Can I have one recordset execute a Select and then have another recordset execute a different Select, and then check if a field from the first recordset is different from the field in the 2nd recordset and if so write out that row on my displaying table?