I'm uploading a file to my server, and I retrieve the filename. Now I can print out the filename with response.write(filename) but when I try to insert the filename into access I get a "cannot be a zero-length string." error. I'm assuming its because the filename was read in using binaryread. So how would I convert this back into a string?
View Repliesi need to convert a string to hexadecimal prior to posting it onto the next page...how do i pass the field value to the function prior to posting ? Code:
<%
Function StringToHex(str)
' conversion here
End Function
%>
<html>
<head></head>
<body>
i hope my doubt is clear. i tried looking in the posted forums couldn't find anything . Anyone know how ?
im trying to input some data into a database from a text box to a field with a text data type the problen is when i try to input "44/22" it goes into the database "2"
so it makes the math process
so how can i fix this to insert the 44/22 into the database ?
I've got a string that contains commas and semi-colons to be used as delimiters. It looks like so: 1,1;4,2;
I'm trying to write a function that will turn similar strings into a multidimensional array, but I'm having problems.
Code:
Function fncCreateMultiArray(strString, strDelimiter)
arrOneDimension = split(strString, strDelimiter)
For i = LBound(arrOneDimension) TO UBound(arrOneDimension)
arrTwoDimension = split(arrOneDimension(i), ",")
Next
fncCreateMultiArray = arrTwoDimension
End Function
i am trying to connection to the datbase and retrive information from it. At the same time i am using some updation satements.The problem here is i am not able to store values in the database which i declared as 'int'.i tried every possible way.suggest me a way to write into 'int' fields in asp. Do i have to use JScript?? do post if you have any code related to this topic.
View Replies View RelatedHow would I convert a string to integer? e.g July to 7 . How would I make use of a graph in asp? I need to put a organogram into a intranet site.
View Replies View Relateda = "1"
b = 2
how can i convert a string var to a number var? how can i make the a var to be numerical,so I can add it to b?
I have a form that gets a filename from a db like so
<FORM METHOD="POST" encType="multipart/form-data" ACTION="pic_delete.asp">
<input type="hidden" name="File1" value="<%=rstemp("filename")%>">
<input type="hidden" name="ImageID" value="<%=rstemp("ImageID")%>">
<INPUT TYPE=SUBMIT NAME="cmdSubmit" VALUE="Delete" ></form>
when I submit I get the error message "File not found"
So a did a respnse write to write my filename and found it is now called 2006_Apr_19-83955.23.bin It seems to be the time as it changes each time I try and get the filename to write...
this is the code on my delete page
<%
Dim Upload
Dim FileName
Dim Folder
Set Upload = New clsUpload
FileName = Upload("File1").FileName
response.write "Here is the file " & FileName & " name <br>"
Folder = Server.MapPath("..country") & "" & strPathToSave
response.write "Here is the folder " & folder & " name"
Upload.DeleteFile Folder & FileName
'Upload("File1").SaveAs Folder & FileName
Set Upload = Nothing %>
The folder name comes out right, just the filename changes.
which function should I use to convert a simple string to a number?
View Replies View RelatedI need to convert a variable, nNum, into a two-character string. nNum is
always less than 100.
If nNum is 0, the string needs to be "00", if it's 1, it needs to be "01",
if it's 34, it needs to be "34".
What's the best way to do this?
I have an asp application by the means of which I'm sending cellphone icons in otb format to a company who sends them by sms to the user. The company requires those otb files as hex strings.
Does anyone have an idea how to do that?
How to convert Object to String
I have objError.Description, i need to convert string in order to use InStr function.
I tried using CStr, which doesn't work
I get the EmpID from the form which is a variant. When I do the following, I get an overflow error. Can you suggest of a way I can convert this EmpID to a number?Code:
'Get the EmpID from the form
strEmpID = cInt(Request.Form("empid"))
VBScript is the scripting language I am using.
I've got an ASP script connected to a db table with a datetime field which is filled mannually for each record. When I want to select only those records with a date greater than todays date using this sql query:
Select * from fixtures where home_team_code = '" & idno & "' or away_team_code = '" & idno & "' and game_date > '" & today & "' order by game_date asc
it returns all records rather than only records with a date in the future. Is this something to do with the fact that i'm comparing a string to a datetime?? Can I use a VBScript function to make the string comparable to datetime?
i want to covert a querystring to float number in asp.what function should i use?i know cint() can convert string to int but how about float?
View Replies View RelatedI'm reading through a txt file and using split to create an array of values. I need to convert one element in the resulting array from a string to a number.
However, none of the conversion functions such as CInt, CSng, Val work. I consistently receive a 'type mismatch' error.
I want insert string date from web form into oracle DB, using following to get date value:
sUpdateTime = Request.Form("date")
the date format the user enetr on the web is mm/dd/yyyy: h24:mi:ss (e.g. 04/13/2005 13:35:01). UpdateTime datatype in Oracle is date, so when insert sUpdateTime into DB, using following code got problem, I knew using To_Date (...) in the insert sql, but don't know the syntax.
strSQL = "Insert into table1 (UpdateTime)"
strSQL = strSQL & " values (?)"
oCmd.CommandText = strSQL
oCmd.Parameters.Refresh
oCmd.Parameters(0) = sUpdatetime
oCmd.Execute
How can I get the Celsius temperature of a string and convert to Farenheit?
<%
Celsius = (Fahrenheit - 32) * 5/9
Fahrenheit = Celsius * 9/5 + 32
testString="it is 30C today and will be 32C tomo"
testString=Replace(testString, "find celsius", "replace with Fahrenheit")
response.write(testString)
%>
I need to look for numbers followed by "C", and use that number, convert it and add "F".
I try to convert a string in to date format, but I didn't succeed until now.
I get a specified date in this form:
date = "20060808"
In the first step I convert the date to a valid date-format:
convdate = right (z,2)&"-"& mid(z,5,2)& "-" & left(z,4)
'looks like this now: "08-08-2006"
Now I want to put this value in a date-format to adding and substracting a days much easier for me.
test = (date)convdate
test = test+15
The problem is that I don't know how to convert into date format.
I have a databse I am pulling news from and evetyhing is working fine.I made a asp script to generate a XML page, my issue is if any of the feilds have invalid strings for XML
ie & <>
It will break and will not output a proper XML page.Is there a way to convert a string into a valid XML string, I know in PHP there was a HTML encode, but will that encoding type be safe still with XML output?All I see are examples to load files and convert their text into XML safe strings, I just want to convert strings on the fly without loading external files.
I want to convert the binary data to string. I tried doing the same using following peace of code.
Function SimpleBinaryToString(Binary)
Dim I, S
For I = 1 To LenB(Binary)
S = S & Chr(AscB(MidB(Binary, I, 1)))
Next
SimpleBinaryToString = S
End Function
It works fine when the data is English. But when the binary data contains some Japanese characters the resultant string gets corrupted.
I need to convert a string that I pull out from a XML-feed to a valid date format. The date format in the XML-feed is like this:
2005-01-12T10:06:42.8130000
I want to change convert to a date type, in
this format:12.01.2005 12:06:42
(mm.dd.yyy tt:mm:ss)
I have 3 fields....Name, CC, and Number. I want to combine all 3 fields to become 1 string...example:
Name:VRAO
CC:415244411258741
Number:125412002
StringCombine: VRAO415244411258741125412002
With that StringCombine i want to convert it to SHA-1 Base 64 format. I not sure how to make the string become SHA-1.
I need to convert html into a multiline string which looks something like this:
shtml = "<table border=""0"" cellspacing=""0"" cellpadding=""0""
width=""720"">" & _ "<tr><td width=""100%"" valign=""top""><br>
<!-- MainTable -->" & _
....
Is there a tool that can do this?
if my month is represent by numbers. like 2, 4, etc
i recognize this as a string but then i want to store it as int
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the varchar value '2, 2, 2' to a column of data type tinyint.
/ords/asp/custorder_view.asp, line 41
u can see the varchar value to colum of data type tinyint
I am working on a database that collects information about incidents. One of the fields that people enter is the time of the incident. I am trying to convert that string that people enter into a OdbcType.Time and I am at a lost.
View Replies View RelatedI'm looking for a way to check if a directory has any filenames with 'w9' in it, and if so print 'yes' in the appropriate place. My database has a field called CustomFieldFilesDir where the appropriate folder structure is already entered for each person ex. 'p:john doe'. I've searched and found scripts that look at extensions but not the file names themselves.
View Replies View Relatedi have this form to upload a document to a folder on the server. i have a field where you browse the files on your computer to upload to the server. once that field is chosen i would like another field to be populated automatically with only the document's name, without the path extension on it. does anyone know how to go about doing this?
View Replies View RelatedMy problem is: i need to write an ASP page which first checks whether
the user has permissions to download a ZIP file, and then streams the
file itself if the user is allowed to see it.
I have succeeded until
this point, but the client browser asks to save the file with the
original filename (and ASP extension). Obviously this would mean
making the downloaded file unusable at client side, unless I tell the
site user to manually rename it, but this is not a solution.
So I ask you: is there any way for an ASP page to stream data to the
browser and have it saved with a default file name and extension which
are different from the page's ones? Code:
I want to have a form where there is a textfield and a Browse... button to the right of it. I want the user to be able to press the Browse... button and select a file and then that filename be returned to the textfield.
I don't want it to upload it or anything like that...I just want to know the filename that the user has selected. Also, when the user presses the Browse... button, I want it to automatically go to a certain place.
I have an asp file upload facility on my website and I now want to add a timestamp to the name of each file uploaded to my webserver to ensure no clash of names.
I have no idea how to code it so egfile.txt will arrive on the server as egfileYYYYMMDDhhmmss.txt (or something similar).
Is it possible to do?
What string function(s) would I use to extract just the filename from an URL?
For example, if I have http://www.yourdomain.com/some_directory/some_file.asp, how do I extract just the "some_file.asp"?
I've created an upload application that allows a user to upload a file a space on the web server.
What I want is when a user selects the file to upload, when the upload process takes places, a random number is generated and added to that filename.
I work out I can add the code:
intrandomnumber = Int((1000000-1+1)*Rnd+1)
but how do you do the change to the filename when it uploaded as I can change the filename name but the physical filename name would be the filename held on the user PC?