I'm trying to write an Update statement with the following code:
conn.execute= "Update Director_Appraisals Set Section1Comments = '" & Section1Comments &"' WHERE UserID = " & Request.Form(hfUserID)
I'm receiving this error:
Request objecterror 'ASP 0102 : 80004005'
Expecting string input
/App/Director_Update.asp, line 122 The function expects a string as input.
I am trying to create a shopping basket in asp and it works in setting the cookie and when it response.writes it sets the correct productID, however i keep getting the error message for the line "Response.Cookies (CookieName) = CookieString" reffering to the CookieName it says it it is expecting a string input, can anybody help please?
<%
dim CookieString
dim CookieName
CookieString = Request.Form("qty")
CookieName = Request.Form("ID")
'Response.Write Cookiename
Response.Cookies (CookieName) = CookieString
%>
<form name="buy" action="quantity.asp" method="post">
<p>Quantity:</p>
<input name="qty" maxlength="2" size="2" />
<input name="ID" style="visibility:hidden" value="<%=ProductID%>"/>
<input type="submit" name="buy" value="buy" />
</form>
I'm not a asp expert and only use the built in Dreamweaver stuff, the problem I'm getting is a datatype mismatch due to the fact the sql statement is expecting a text string and not a number string, can anyone have a look at the following code and point me in the right direction in regards of what I need to change so the sql statemnet know to expect a number string: Code:
View Replies View RelatedI have problem with multi-language string values. I have an input box, which accepts max 75 chars. Value goes to SQL server table field VARCHAR (75). it was okay with english language but error comes when saving Arabic or any RTL language.
I checked the values by
Response.write len(myRecievedString)
OutPut:
Lenght of String Containing 75 English chars: 75
Lenght of String Containing 75 Arabic chars: 525
Shall I increase the size of table field?
I have a little code to add multiple items to a shopping cart based
page. This code works perfect, but it adds all of the info to the
same input fields every time it loops. I need it to change the input
names each time it loops. Here is the code:
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
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 .....
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 RelatedI 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
I have an input box that sends data over to the next page. This
input box was in a loop, there creating data looking like this: 2, 0,
0, 3, 0, 4, 0, 22, 0, 0, 0
How do i break the data up in such a way that i can populate it into my
db while running through a recordset?
I have a problem with :
<input maxlength="10" name= "DateRep" type="text" style="width:115" onchange="UpdateCentralRep();" value=<%=Date()+1%>>
when its run in a MAC machine, it reload de whole page, instaed call UpdateCentralRep.
It works ok in PC!!!
i create a dynamic table to modify user/account for administrative management.
I have modify & delete function to be performed.
The idea is that when the admin click the Delete link, he can delete a particular account/user. is it possible to pass variable of buff value to recID??
because when i see the result of request.querystring("recID"), i does not pass the mumerical value sound pretty simple but i can't get it. Code:
when I use:
<input type=button id=Test>
the following code works
myform.Test.disabled = true
When I change the input box to type image none of the properties are available. I get the message "object doesn't support this property or method"
Can anyone tell me how to fix this.
I am looking for something similar to "preg_match" and "preg_match_all" in PHP.
I have searched the forum with no luck. I hope you are able to give me some pointers
Basically I want to match some text from a form and loaded it into new variables making use of regular expressions. the text comes form a textarea input type. Code:
I have a bummer here. I have 3 sub R. that I need to call from a input button. I set up the following line, but the script just calls them with out having the button pressed. OOOO! Any ideas?
<form method="submit" name="nreg" onsubmit="(this)" action="call readitme, call saveitme, call reduce" >
I have also used method="POST" same darn thing, script just runs the sub R. with out being pushed or cliked. UUUGGG
Is there any way to clean the user input before saving to the database.I tried to use..
Function StripNonNum(strInput)
Dim regEx
Set regEx = New RegExp
regEx.Pattern ="^[w-.]{1,}@([da-zA-Z-]{1,}.){1,}[da-zA-Z-]{2,3}$"
regEx.IgnoreCase = True
regEx.Global = True
StripNonNum = regEx.Replace(strInput, "")
End Function
But It doesn't work when user cut&paste the information to screen.For eg.Cut&Paste from a CV which contains Bullet points is there any way to remove these bullet Points before data saving..
when using a file input it only returns the filename
is there any way of returning the full path and file name?
Code:
<input type="radio" name="dewey_loc" value="dewey" onClick="toggledewey()" checked>Dewey
Can't seem to work out how to call an ASP/VBSCRIPT function from within html, is this able to be done? Can call JS without issue, but need to change a Session variable when this radio button is clicked.
I have found that places double quotes ' "text" ' around text inside (INPUT) tags results in everything after the initial quote, '"' gets truncated.
I'm passing the form information to another form to allow the user to look over and validate what they're submitting, then they will click the submit
button to send it all along.
I'm finding that in the validation form, the quoted text inside the (INPUT) tag gets truncated. However, the quoted text inside a TEXTAREA tag does not.
I'm using the following code and if someone enters something in the "instructions" field with characters -"', - it causes the SQL statement to change using those characters.
Dim strSQLadd
strSQLadd = "INSERT INTO orders" &_
"(form_number, orig_number, order_loannum, order_date, order_time, order_address, order_city, order_zip," &_
"order_contact, order_lockbox, order_agent, order_homephone, order_workphone, order_cellphone," &_
"order_legal, order_instructions, order_deliver, order_pay, order_altmail, order_appraiser) " &_
"VALUES (" & FormNum & "," & OrigNum & ",'" & CaseNum & "','" & OrderDate & "','" & OrderTime & "','" & pave & "','" & City & "','" &_
Zip & "','" & Owner & "','" & LockBox & "','" & Agents & "','" & BorHmP & "','" & BorWrkP & "','" &_
BorCellP & "','" & Legal & "','" & Instruct & "','" & DeliverType & "','" & Payment & "','" & AltMailType & "','" & AppName &"');"
objconn.Execute (strSQLadd)
i have a software application and i have to import around 250 users data into the app.
I want to automate this step,it the most common info
like FN,LN,e-mail etc.
The app runs on IIS and uses ASP. I am looking for a GUI input Automation tool which will have scripting capability to take input from a text file and fill the user input fields "automagically".can testing tools like winrunner do this for me?
how to input textfield in popup window to search from a database and generate the report in another page?
View Replies View RelatedI am in the process of writing a website which has an access database
and uses asp to access it. Part of the site is a search facility. I
have heard that it is possible for hackers to gain access to the
database by entering SQL in to the search box. First of all is this
possible? Secondly if it is possible, what sort of syntax should i be
checking for on the text entered in to the search field
I have an ASP page that has a Form & Inputs that are related to an XML file. I would like to prepopulate the value of the Input with the corresponding field from the XML file.
View Replies View RelatedI have a simple problem :
When I try to pass a variable via an hidden input and it contain a word with a space (ex :The Wall), only the first part is sent(ex: The).
<INPUT TYPE=HIDDEN NAME="Charge" VALUE=<%=Charge%>
I limit the quantity of characters in an input box. I need to limit the input to 10 for example.
View Replies View Relatedi let the user go and submit his phone number in a particular page. on the other side on access i adjusted my input mask of that particular field to the following set (999) 000-0000;0;-
or (&&&) &&&-&&&&;&;- or (@@@) @@@-@@@@;@;-
when i open the database i see the phone numbers are stored in the fine format which i wanted, however when i try to retrieve the data using the browser, i just gets me the phone number like 29384838283 without any brackets or spaces.
How can I create a query based on the form input. I want to have a pulldown menu (list of states). The user can select the state, lets say VA and click on "go" button. I want the page to return results that has state=VA. So how do I create that statement and send to aspx ?
View Replies View RelatedI've 2 RS and would like them to apprear on the input box. What did is :
phonenumber= ((RS("Acode") & "-" & (RS("phone")) Code:
<input type="text" name="phonenumber" ID="Text1" size="20" value="<%=phonenumber%>">
for some reason, it just displays only RS("Acode") , NOT the whole thing. Am I doing right?
I'm using an input box in a form
(<INPUT TYPE="SUBMIT" NAME="btnLocation" CLASS="btnLocation" value="<%=btnString%>">).
Is there a way to put this button in a disabled state, where it can't be clicked? I've tried adding an "enabled" property, but that doesn't work. I've even tried "visibility" property, but the input box doesn't seem to support that either.
i was wondering if i could enable/disable input according to the user, e.g.
enable input2 if input1 is enable, else it's disabled. Also, if input1 is
deleted then input2 is disabled.
I have an ASP page that acts as a log-in page. THe user is instructed to input a password. I was wondering if anyone knows how to default the cursor to that input box. This way the user does not have to move the mouse and place the cursor in the input box, they can just start typing a password.
View Replies View Relatedi create a dynamic table to modify user/account for administrative management.
I have modify & delete function to be performed.
The idea is that when the admin click the Delete link, he can delete a particular account/user. is it possible to pass variable of buff value to recID?? because when i see the result of request.querystring("recID"), i does not pass the mumerical value sound pretty simple but i can't get it. Code: