Passing A String
How do you pass a string parameter that contains a slash (for instance a date) to a com object? I pass a date with slashes and I get "Type Mismatch" with the date 05/16/1974 being interpreted as 05%2F16%2F1998.
View Replies
ADVERTISEMENT
String Passing
Having a little problem with this.
response.write "<A onclick=sendme() target='myNewWin' HREF='filter.asp?ins="
& insName & "'>"%>Advanced Filter</a>
I need to have a single quote around insName.
I tried the following:
Function sIn(s)
sIn = "'" & Replace(s, "'", "' '") & "'"
End Function
sIn(insName)
but that is not working.
Passing A String
i m passing a string like "NEW PAGE" thru the URL itself.. when i derive the value using request.querystring("<somename>") i get only NEW.. i tried to pass it thru session but still i get the word NEW.. i dont want to pass it in sessions...i need to do it thru URL itself. y such a prob occurs?
View Replies View RelatedPassing A String That Has Spaces
I have a View button that shows a database record of entries. At the end it has a delete link for each entry. When u click it, it passes the Address(like a house address) to a script that searchs the DB for the matching address.
The only problem is most address have spaces. I read somewhere about double quotes, or using single quotes or some combination, I don't remember.
Passing String To Server.MapPath
How can I pass the results of a form field submitted to this statement
below?
<%
Set MyFileObj = Server.CreateObject("Scripting.FileSystemObject")
'### This Works
'###Set MyTextFile = MyFileObj.OpenTextFile(Server.MapPath("body.txt"))
'### This Doesnt work
Set MyTextFile = MyFileObj.OpenTextFile(Server.MapPath(" &
request.form("MyFileName") & "))
WHILE NOT MyTextFile.AtEndOfStream
Response.Write(MyTextFile.ReadLine & Chr(10))
WEND
MyTextFile.Close
%>
Passing Email In String From One Page To Another.
I have a page that pulls data from a database, one of the fields is Notetext
which frequently contains an email. I then want to pass this onto another
page, that updates the email field in another database, so in page 1:
strNote = rsnotes("NOTETEXT")
And to pass to the next page:
<a
href="createemail.asp?strIssueNo=<%=zero(rsnotes.fields(0))%>&strNote=<%=str
Note%>"><img src="Images/createemail.gif" width="75" height="25"></a>
It all works fine except that only about half the email gets copied into the
other database. It's not an issue with the database as it can take that
length of characters.
So my question, Is there a limit to the number of charachters you can pass
from one page to another in a string? and if so is there any way of
increasing this or getting around it?
Batch File: Passing A String Variable To Sql Script Results In Truncation
I have a batch file that takes variables from the cmd and passes them by sqlcmd to an SQL script. When I pass the variable 'MikeTestList' the script runs as expected with no problems. When I passed 'BulkTransferTest' I got an error message, 'The string or binary data will be truncated'.
Some testing has shown that I get the error when the string is anything above 12 characters. Is there a limit to the length of a string you can pass using sqlcmd from a batch file? Is there any way around it?
Also, if I have a space in the string, it only passes the string up to the space. I have tried to fill it with a '%' which then gets passed as is, so the % stays in place through out the script. Code:
Web Forms / HTTP File Upload / String.Split A StreamReader.ReadLine() String
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 .....
String Functions Run On Empty String
I have a form in which several elements are expected to be all digits. Some of those elements can be left empty, but if specified they must be all digits. I have this Sub to edit them: ....
View Replies View RelatedText String To A Interger String
I am pulling info from a sql server By default the query pulls back the inforamtion as text.Therefore when I go to calculate some figures its giving me a type mismatch error.
Is there a function in can call to convert a text string to an integer string using
rstSearch.Fields("name").Value .To pull back the info in a for loop
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch
Passing Through A Var
I need to click on a button and pass through a variable with a number
associated to it to other form
That is. I know I can do something like this:
<FORM action="http://somesite.com/prog/adduser" method="post">
<INPUT type="submit" value="Send"> <INPUT type="reset">
</FORM>but.. can I do something like this?<FORM
action=http://somesite.com/prog/adduser?data=14 method="post">
<INPUT type="submit" value="Send"> <INPUT type="reset">
</FORM>
How do I do it?
Passing Value In UPL
I have some code which I use server.Execute. In the included code for
the server.execute, if I use a Request variable I get an error stating
that I cannot use request after UPL but If I change all the variable
names from request
to upl, it tells me that UPL is not defined.
It seems that the page is passing the form values for request but not
UPL
Passing IDs
I have got a news section which i am working on i can get all the news items to display the short description and title with the link to the full item but when i click on any of them it takes me to the very first record in the database. i have been told that the problem is with the ids not being passed through properly but im not sure.
View Replies View RelatedPassing Value
I have a small problem.How can I pass value from form thru a few pages. I try with hidden field but my second page just validate and redirect to other one and when I use Request.Form("field") it's nothing coming back.
View Replies View RelatedPassing Through URL
I am creating a simple news WAP site which uses a database. The database consists of three columns, storyid, storyheadline and story. The first page outputs the storyheadlines. When the user clicks on the headlines, they are taken to another page. The storyid is passed through the url (stored as storyno) and the next page loads the story which matches the headline. So basically, I need to know how to correct this:
SQL = "SELECT * FROM gmscwapstories WHERE storyid = <% Request.QueryString("storyno") %>"
This doesnt seem to be working.
Passing A Value
how to properly parse this so "Cute & Cuddly" passes to the calling page. I need to pass the & sign.
<option value="search.asp?category=Cute & Cuddly&subcategory=brown">
Passing Url
I have a members only section of my site, which is protected and works fine, but i want to be able to alow the user to update their profile. Problem is, i don't have anything to pass in the url.
In the member record update section of the admin, i have the url, as it leads on from the chosen members id....eg...www.xxxx.com?id=2.......like that. But where the user updates their profile, it has nothing to send data from...eg...a form/recordset. Could this be done by storing it in a cookie or something?
Passing A Value
I'm trying to display data from three tables. The main table has a Record number and the other table contain the same number. I need to pass the parameter value (record number) from the main table to the other tables (table2 and table3) and display there data on the same web page.
i can get the three recordsets open, but I can't select table2 and table3 by the record number from the main table. I also need to be able to move through the recordset one record at a time backward and forward.
Passing A Value
I am trying to pass a value in a way that after a user has successfully logged in to an ASP app through a form, their login id would be passed to a welcome page.
for e.g. after their login they get to a page saying "Welcome User what would you like to do? " This is probably simple but I am new to ASP,so how can this be done ?
Passing Values
Is there a code, or something that scrambles the value being passed fromone asp page to another??
what I mean is this:
if i want to pass a value from a database (record id #721) from my page records.asp to recordview.asp
it might appear like this in the browser window, or when u highlight the link on records.asp:
recordsview.asp?K=751
I don't want users to see exactly what record number is being access... so I'd like it to show some garbage in the browser like
recordsview.asp?@$@#$=DSFSD+jklsjkld
you get my drift...
Passing Variables
This is hopefully a really simple issue... but what is the best way to pass a variable from one .asp page to the next?
View Replies View RelatedPassing Variables
I'm trying to post variables using http to a site with a different domain and need my page to wait until it gets a returned value back and then insert that value returned into a database. Once I'm able to get the variable back i know how to get it into a database, just don't know how to have the page wait for the value returned.
View Replies View RelatedASP Values Not Passing
I have a submit form that collects my values, and if my form action is "mailto" the values are passed, but if I try to pass to another asp page the values aren't sent and the asp doesn't execute.
View Replies View RelatedPassing Variables
I am trying to write a search application which will allow a database holding a text to be searched.
To search the text the user has to select the act, the scene, the character
Right this is where it gets tricky!
The acts all have different scenes and the scenes all have different characters - so rather than try and attempt a very complicated linked combo box for the act, scene and character I figured a more sensible way of doing it would be to have the user enter the act they want to search on one page. The value of this would then be passed by form to the next page (to get the scene).
Based on the act selected a dropdown box is then populated with all the scenes for that particular act. Following on from this I then want to pass the scene selected together with the act selected on the previous page to the next page which will get the character. I can get the scene value passed through to the character page but not the act value as this is now a server side variable. Basically what I want to end up with is after the user has selected the character on the third page, I want to be able to use all this information to build an SQL search statement.
In case you are wondering why I decided to do it in this way, I initially tried the linked combo box method but found that if the user doesn't click the boxes in the correct order it causes problems with updating the box contents. Doing it this way I figured I can force the user to enter the information in the correct order. Code:
Passing A Variable Into An SQL
I am trying to make a variable appear in an SQl but am not sure how. Here is the sample code:
View Replies View RelatedPassing Value To The Same Form
I have a form and from there I click on link to open a search page, choose an item(checkbox), then that item should appear in the same form I first opened. I tried javascript onClick event such as :
<input type=submit name=submit value=Submit onclick="javascript: form1.submit();">
and also tried:
<input type=submit name=submit value=submit onclick='http://myformurl/form.asp'>
It is only opening a new form instead of the same one. How can I do to choose to pass the value to the same form?
Asp Passing Values
i m using frontpage to create a login form using SQL SERver database. i want 2 redirect the value of username & password to another page.
View Replies View RelatedPassing Variables
Is there a way I can pass a javascript variable's value and use it in my asp code?
This is what I am doing:
I have a checkbox.
onclick="SelectView('course')"
javascript:
Function SelectView(course){
var course
course = 'course'
}
then in ASP (again)
if (javascript variable course = course) then
do something
end if
Passing Variables
I've got a form that has ENCTYPE="multipart/form-data" - this works great for getting a file from the user, however, no matter what I've tried, I can't seem to get any of my other fields passed to the next page. Here is an example:
<input type="text" name="lname" value ="<%= request.form("lname") %>"> I need the "name" field to be passed to the next page.
This if my form tag:
<FORM NAME="UploadFile" METHOD="POST" ACTION="UploadFileAck.asp" ENCTYPE="multipart/form-data">
I've tried an onblur when a name is entered, but it still doesn't recognize the lname field. Any ideas would be appreciated!!
Passing Variables
I hope I can explain this without much confusion.I have a search box on a site that contains 2 forms. One form is a search for Cities (via dropdown box) that goes to citylistings.asp. The other form is a search for Counties (via dropdown box) that goes to listings.asp.
Now I need to add the ability for the user put a Minimum and Maximum price in addition to the above. My problem is that I am unsure how to have just one set of price boxes for both forms. So that you can fill in the prices, and click Submit for either form, and the prices get passed.
You can view the page Here.
A guy who used to code in VB said that I should be able to declare variable, then when the user clicks on the box and types a value, the variable is set to that value. Then I can added hidden fields to the forms that are equal to the variables. Can I do this using ASP/VBScript.Or can I accomplish something similar?
Passing Post
I'm posting a form from a php page to a page that's asp. I want the url parameters sent to the asp page to be the defaults of the form. I've never used asp so I'm not sure how to do this.For example:
www.test.com/test.asp?clientid=123
Text field in asp/javascript form called "client" should now default to "123".
In php I would have put this as the default value for the "client" field in the form: <?php $_GET['clientid']; ?>
What would be the equivalent way of doing it for asp?
Passing Variables
I have a function set up to send out an email. The function recieves parameters(email, subject, body). For some reason the function will only work if I change the function to accept only one parameter. ie. function imail(email).
View Replies View RelatedPassing Value From Form
How do I pass the value from form to SQL insert statement?
Code:
Insert into table values ('A','" &request.form("Textbox1") &"')"
Is the request.form statement correct?It seems that the record is enter to DB but second field is empty.