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.
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:
if strUser="jdoe" or strUser="jsmith" then
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 have a field called cars like this
<input type="textbox" name="cars" value="cars_4500">
when i submit the page i get the value of the cars in a variable
cars=Request.form("cars")
what i want to do is save cars in a variable and the 4500 in a second variable. how i can do it.
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 m designing a online test application. my reqt is on pressing next button my selected value gets stored in the database and next ques ll appear and on pressing prev button it should display me previous question with already selected value.
how can i do this?
how can i pass selected value of radio button through query string as my radiobuttons are getting cerated dynamically.so every time its name will be different. Code:
I am working with an ASP app that creates reports based on data in an SQL Server 200 database. There is a web form with select boxes for the user to select their criteria, and based on that an SQL SELECT statement is generated.
One of the requirements is that some fields need to be multiple selections. The output of these fields are in CSV format (One, Two, Three). These values are all alphanumeric, NOT just numeric....
I have the belwo code which i mean to do an multiple checkbox insert. I have managed to get it so i puts all the checkbox values into a string seperated by a comma, and it insert into a database, however just not how i need it to.
Curently inserst like :-
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 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'm developing an Asp.NET system to take a CSV file uploaded via the web, parse it, and insert the values into an SQL database. My sticking point comes when I try to split() the string returned by readline() on the file.
The following code snippet works for me:
tokens = "one,two,three,four".Split(",")
for each token in tokens
response.write("<td>"+token+"</td>")
next
However, if I take the next line in the CSV, read using StreamReader.ReadLine on the PostedFile.InputStream, I receive "Object reference not set to an instance of an object." which I have narrowed down to be my string holding the line. Further investigation reveals that no other string member functions work on my line (.ToCharArray, .ToString, etc).
I suspect that StreamReader.ReadLine is not correctly returning a string, even though Response.Write(line) displays what I would expect .....