Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Display results from SQL query in text box
Thank you so much that has worked perfecly.- leppyk
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
Display results from SQL query in text box
I am tryin to display the value from this sql statement in a text box on the web page. strSQL = "select sum(POVal1) from projects where project_code = '12345'" objRst.Open strSQL,objConn,adOpenStatic objRst.Close However when i look at the text box it contains the select statement instead of...- leppyk
- Thread
- Replies: 2
- Forum: Microsoft: ASP (Active Server Pages)
-
Convert String to Int
Thank you all so much for your help, i am doing this as a favour for a girl at work and i'm not very familiar with coding. The top of the page is has <HTML> <HEAD> <META name=VI60_defaultClientScript content=VBScript> <META NAME="GENERATOR" Content="Microsoft FrontPage 4.0"> <SCRIPT... -
Convert String to Int
it converts the string representation of a number to its 32-bit signed integer equivalent. the error i get is Microsoft VBScript runtime error '800a01a8' Object required: '' When i use the CLng function i get Microsoft VBScript runtime error '800a000d' Type mismatch: 'CLng' -
Convert String to Int
Thanks for your repsonse, when i use that function i get the error type mismatch. If i use System.Int32.Parse(STRINGNAME) i get Object required: '' error. Any ideas what is wrong? -
Convert String to Int
thanks for your help, i haven't used this before so i will show you what i have and could you explain how i can add that to the code you gave me? txtPOVal1 = trim(Request.Form("txtPOVal1")) txtPOVal2 = trim(Request.Form("txtPOVal2")) txtPOVal3 =... -
Convert String to Int
this function is to convert numerical values from one type to another. i need to convert a string to an int. -
Convert String to Int
i have 3 text amounts and i need to create an int total of them. how can i convert the 3 amounts to long ints so i can get a total of these fields.
