Multiple Queries And Using Their Values

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:

View Replies


ADVERTISEMENT

Multiple Queries

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.

View Replies View Related

Multiple Queries On Single Connection (classic ASP And ADO)

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:

View Replies View Related

Multiple Values

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") )%> ">

View Replies View Related

Allow Multiple Values

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:

if strUser="jdoe" or strUser="jsmith" then

View Replies View Related

Multiple String Values

how can I compare a values to multiple string values. i.e.

If Request.ServerVariables("REMOTE_ADDR") = "213.123.214.33" Then
WriteLine "A problem has occured, please email for help<BR>"
end if

Would it be to do multiple if the elses, case or can you put all the possible values on the one line? i.e. "123.123.123.23" or "345.234.234.234" etc.

View Replies View Related

Insert Multiple Values

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

View Replies View Related

Multiple Values In One Field

how do i insert multiple values into one database fields using ASP.

View Replies View Related

Multiple Values From QueryString

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.

View Replies View Related

Passing Multiple Values

I have a link as follows:

<A HREF=""Tracker.asp?MovementID=" & RS("MovementID") & " PONumber=" &
RS("PONumber") & """>" & RS("MovementID") & "</A>

I am trying to pass: MovementID & PONumber.
On linking to Tracker.asp,

MovementID = 2257 PONumber=21071045
PONumber = Empty

I am just testing this with Request.querystring. What have I done wrong, how can I separate these values ?

View Replies View Related

Using Replace() For Multiple Values

is there a more efficient way to replace multiple values than this (so that the numbers 0-9 are placed with particular texts in one go): Code:

View Replies View Related

Displaying Multiple Values

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.

View Replies View Related

Request Multiple Values

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?

<input name="idioma" type="checkbox" class="campo" value="1">Portuguese
<input name="idioma" type="checkbox" class="campo" value="2">Germany
<input name="idioma" type="checkbox" class="campo" value="3">Russian
<input name="idioma" type="checkbox" class="campo" value="4">Spain
<input name="idioma" type="checkbox" class="campo" value="5">French
<input name="idioma" type="checkbox" class="campo" value="6">English
<input name="idioma" type="checkbox" class="campo" value="7">Italian

Can anyone Helps me?

View Replies View Related

Retrieve Multiple Values

I have some problems in trying to retrive multiple parameters from a stored procedure. When i want to just get one i use

select @param AS 'para'

But how should i do when i want multiple parameters out to the ASP files?

View Replies View Related

Multiple Page Values

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?

View Replies View Related

Return Multiple Values

At the moment, the function looks like 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?

View Replies View Related

Send Multiple 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?

View Replies View Related

Returning Multiple Values From A Function

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:

View Replies View Related

Multiple Values For Radio Buttons

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?

View Replies View Related

Returning Multiple Values From VBScript Function

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:

View Replies View Related

Post Multiple Values For One Form Field

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

View Replies View Related

VBScript Function Returning Multiple Values

Is there a way to return multiple values from a function without using an
array? Would a dictionary object work better? Code:

View Replies View Related

Freeaspupload: Retrieving Multiple Values From A Select Field

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:

View Replies View Related

Retrieving Multiple 'values' In A Single OPTION ITEM

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:

View Replies View Related

Queries

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.

View Replies View Related

SQL Queries

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)

View Replies View Related

3 Queries Or 1

I have the following page which I am using to select 3 diffrent queries but i was wondering if i could just use one SQL statement instead of 3? Code:

View Replies View Related

On The Fly Queries?

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?

View Replies View Related

Sum() In SQL-queries

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?

Total is: 45.

Product1 costs 13
Product2 costs 8
Product3 costs 24.

<%
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)
%>

View Replies View Related

Stored Queries

I am running the following code to an access database

' Recordset Object
Dim rs

' connecting to database
con.Open connStr

' executing stored procedure
Set rs = con.Execute ("exec SpotDesc")

' showing all records
While Not rs.EOF
Response.Write rs(0) & " " & rs(1) & "<br>"
rs.MoveNext

Wend

' closing connection and freeing resources
con.Close

Set rs = Nothing



This works and runs the stored procedure SpotDesc.

One question I have is that this line brings back the results

Response.Write rs(0) & " " & rs(1) & "<br>"

but requires me to know how many colums are being returned, ie rs(0) is column 1 and rs(1) is column 2

Is there a way of writing this line and it places all the columns there wheter it be 1, 2, or 3?

Ie a way of know how many columns are returned...

Is there also a way to show the column heading?

View Replies View Related

Can ASP Use Access Queries?

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?

View Replies View Related

Sql Problem With Sub Queries

This "query2" is used in an MS Access environment.

SELECT T_Perso.*, query1.*
FROM T_Perso LEFT JOIN query1 ON T_Perso.IdPerso = query1.IdPerso;

In SQL, "query1" is :

SELECT T_Items.*, T_Items.IdTypeItem
FROM T_Items
WHERE (((T_Items.IdTypeItem)="Inscription"));

I would like to translate "query2" in full SQL language in order to use it
in ASP but I have some problems with syntax and sub-queries.

I suppose it's quite easy but.I'm a newbie in SQL.

View Replies View Related

2 Queries And Then Compare Them?

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?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved