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
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") )%> ">
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.
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 Relatedhow do i insert multiple values into one database fields using ASP.
View Replies View Relatedhow 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 RelatedI 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 ?
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:
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 Relatedhow 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?
<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?
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?
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?
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?
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:
View Replies View RelatedI 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
Is there a way to return multiple values from a function without using an
array? Would a dictionary object work better? Code:
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:
I want to call a recordset so you can edit the details and then obviously pass the parameters onwards into the db. However, the user guide just says this:
To process other fields in the form, use the Form collection of the upload object the same way you would use the Form collection of the Request object. For example, if your form had a text element named UserName, your processing code would include: Code:
i need to convert the escape values which are by mistake updated in DB.
example:
this is a sample text string
is updated in DB as
this%20is%20a%20sample%20text%20string
here %20 is the space.
like wise there are many entries for :,'
is there way that i can update all this in a update statement?
or use asp to to update the records?
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 have a variable SET which has the value Of 1, 2, 3, .., N.
SET=val1, val2, val3, val4, ..., valN
What is the commend or procedure to extract individual values, val1, val2, ...
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 to get values from table using arrays can anyone tell me how this can be done here is my code
Code:
For i = LBound(arrCart, 2) to UBound(arrCart, 2)
Set rssubcat = Server.CreateObject("ADODB.Recordset")
strprod="select Member_Price from Products_Price where Products_Price.Product_Id= '" & arrCart(cartProduct_Id,i)"'"
rssubcat.Open strsubcat, Conn
total=rssubcat("Member_Price") * int(arrCart(cartQty, i))
subtotal=subtotal+ total
Next
I have a main data entry form which has a link to a detailed data entry form. The value of the link in the main form is the sum total of all the line items in the detailed form. The detailed form has fields to capture the individual line items like contracted service expense, travel expense etc. I am capturing the total of individual line items using session variables so that when the values of the main form is saved these total of line item values get saved. However, if one gets to the mainform via login and tries to resave the values (which is already saved), the above session variables (from the detailed form that contains the sum of line items) get null values. However, just navigating to the detailed form through the link and coming back to the main form sets the value in the session variables.My question is how to get the session variable values without having to go to the detailed form and come back to the main
View Replies View Relatedif it is possable in ASP i could store a value in one ASP page and look at it on anouther ASP page. for example:
On a login page i want that page to store a value called rights that is a number. when it goes to any of the other pages EG add user, Delete users if the user does not have the needed rights to takes it back to the main screen.
I wish to get and set values on child controls on a formview.For example. Changing the text in textbox. Hiding or unhiding child controls based on user. Replacing a blank with a default or calculated value that will need to be generated at runtime.It seems as though this should be thoroughly documented, but I'm not finding much.
View Replies View Relatedi need to know if i have a loop that outputs values for each month how do i get it to add the values and only display them every 3 months,(every quarter)?
jan
123
feb
234
mar
432
first Q
789<---------how do i do this?
Apr
125
may
548
jun
323
second Q
So on..