I need to modify some code written by someone else that sends out an automated email based on a form submittal. In the form, values are set to 1 or 0 for "yes" or "no". I need to modify it so that the email changes the 1 or 0 to their text equivalents (yes/no).
I CANNOT modify the form itself to change the variables, so i assume i need an IF stmt to that converts the string to text before it sends. Can someone point me in the right direction for how to do this?
I need to insert some number into database as text. My problem is if I insert the number (ie. 4.0), the value in the database only show (4). So, is it possible to convert a real number into text number using ASP?
View Replies View RelatedI am making a check writing page and was wondering how to convert a variable in the form of $1234.56 to One Thousand Two Hundred Thirty Four Dollars and Fifty Six Cents (Or something like that).
View Replies View Relatedis there anyway to convert a number into a text string? i.e. 1 to one or 2 to two.
View Replies View Relatedwhat's the easiest way to convert a number to text i.e.
2005 --> two thousand and five
67 --> sixty seven
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'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.
This is related to my earlier post.
Ok I am reading a text file (LOG) the time is extracted from the text file and looks like this 07:56:11 with no spaces on either end.
My problem is that the format is not time (when writtern to a varible) so I cannot write it to a table field with a time format. How do I covert the above number into time.
I am using filter to build a recordset of records using:
Recordset1.filter="sorter >'"&todayDate &"'"
I dont think that the sorter field is a number, so how can I ensure this at this stage?
I have a client that originally wanted me to develop their webapp using PHP and MySql.
It now looks like I have to use ASP/MsSql to do the job.
They need to search for words in ms word documents that are to be uploaded to the server.
In the PHP environment I could use a PHP class to extract the text from the word document and then put the extracted text in a database field to make it searchable (fulltext index etc). All doable from within one PHP script.
I have looked around the web to find some similar to use with ASP but with no luck.
What I want to do is this:
User uploads a .doc document to the web-server.
The ASP script should then be able to extract the text from that word document so I can put the text in a db field to enable fast search for matching documents.
Is this doable from within ASP script?
Is there any third-party solutions available out there?
I am trying to compare a variable with a db plain text field as follows:
access db has field named HFRNUM as text .... ex: 12182003-A
I create a variable in vb as follows:
Dim hfr_today
HFR_Today = (Month(DATE)) & (DAY(DATE)) & (YEAR(DATE)) & "-A"
Unfortuantely, I think the HFR_Today var is not text and when I look for a record that is LIKE or = the var, it returns blank.
I display my variable and see 12182003-A, yet it does not find the record that matches (except data type perhaps?) Is my variable of a different data type, and if so, how can I make it plain text?
I need to get text posted from a webpage to a image. The text needs to be displayed with fonts that I can't use in a webpage. This is to be used submitting textadds from the web, later to be published in a newspaper.
The image it self will not be published, I need it to calculate the price for the add.
There for I need it with the fonts used in the newspaper. Don't now if this is the right group.
I wish to convert the message received in the text box to be
replaced by the label with the same message as in the text box, After
upload button is clicked this action should be carried on.
So the data in the text box is stored to the database after the button
is clicked and also the textbox is converted to label with message in the
text box.
I'm trying to find the line number of a specific piece of text:
do while textFileOpen.AtEndOfStream=false
if textFileOpen.ReadLine=text2Find then
foundAt=textFileOpen.Line
end if
Loop
But it keeps giving the wrong line number
What I'd like is foundAt to be 0 then if the line is found foundAt is to be the line number, if it is not found stay at 0
In the script above foundAt at increments even though the text isn't in the line?
I also get a "Input past end of file" if text2find isn't found
Im working on a number to text conversion in ASP, just like this : 456 = four hundred fifty six. If you have any cool function, In case you don't, how can I analyze the caracters of a number one by one, and know how much caracters a string has?
Ej = "1234" has 4 caracters
i know in html you can set a "max" character limit for a form field.I was wondering if it is possible to set a min number of characters?
View Replies View Relatedi have several fields in the database that the format is number. then, i have a report page that allow user to open it the ms excel. my problem is, when all data transfered to ms excel, all data that is in number format, they are located at the right of the cells and there is 1 data named noIC, suppose this data is a 12 digits number but in the ms excel, it became something like this 780945+E12....
to solve this problem, i have to change the cell's format everytime all data have been transferred to ms excel. i have to set to left indent for all fields that contain numbers and for the noIC i have to set from General to Number.
I have a text field in a web page I am working on that seems to be calculating phone numbers before inserting them into an Access database. i.e., 867-5309 will result as -4442 in the Access text field. My guess is that the webserver or client is processing it before inserting it. Is there any way to stop this other than using a validation script?
View Replies View Relatedhere is the scenerio
in master batch table i have various master batch like
200701-0001
200701-0002
200701-0003
Now each master batch can have multiple final mixed batch like
200701-0001-01
200701-0001-02
200701-0001-03
and this record is inserted in to fmix table.
so i have a form in which i have a dropdown menu in which all the master batch is listed,
i select 200701-0001 and that value is passed to next page where i will enter other fields data and insertion to my fmix_no will be done automatic like 200701-0001-01, 200701-0001-02 and so on,
how to achieve this
so in short each master batch will have more than one final mixed batch.
pls help, also if u have any online contact in yahoo or msn pls send me, i am so confused and badly struck deadline is just couple of hours away. my yahoo id is(E-Mail address blocked: See forum rules) you can PM me i am online right now.
I want To handel the error messages by myself in one part in my script. I know that in VB I can Use the statment - On error resume next And I also know that I can retrive the Error Number In VB with Err.Number.
How can I handel the errors by myself in ASP? I heard about the ASPErr Object, Is it the same thing like the err object in VB?
I have this problem in controlling a the text in a Text Area. How can I do
that for example the field size is 200, when it reaches 50 it automatically
goes to the next line. Bcoz im having problem when viewing it in my report,
it continuesly views in a strieght line and im having problem in printing.
When using ASP's FileSystemObject to create text files, I am unable to get user submitted text (in Hebrew) to save as anything other than "?????". The text file is being saved in Unicode and setting the CodePage in ASP proved unsuccessful. Strangely, hard coded Hebrew text in an ASP variable does add to the text file correctly.
Any ideas of why this happens and how to get it to work correctly?
is it possible to convert asp.net coding into asp coding?i know out there, theres a software to convert asp code to asp.net.is there a software to convert asp.net code into asp code?
View Replies View RelatedI have a client that wants to send an invoice when a user submits a certain form on their site. From this form it goes to an asp page that calculates amounts, and check for a voucher. It then enters data in database and emails invoice.
But they want it send as a pdf attachment. How do i go about doing something like that. Do i convert the htm / asp to pdf. and send it?
<%
mysql="SELECT * from data"
Set con = SERVER.CREATEOBJECT("ADODB.Connection")
Set rs = SERVER.CREATeOBJECT("ADODB.recordset")
con.open "DSN=database4atc"
rs.open mysql, con
'recordset.open sqlcommand, activeconnection
%>
how to convert to dns less?
Not having luck in converting my DNS to a DNS less piece of code. This is what I have:
Sub Application_OnStart
Application("ConnectionString") = "DSN=DevDivision"
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.open Application("ConnectionString")
SQL = " SELECT AdminEmail, title, footer, p_id from tblSiteOptions "
set rs = Conn.Execute(SQL)
I'm looking for the best way to convert asp to jsp, ideally free software.
View Replies View RelatedI want to convert one .xls file to .csv file using ASP Is there any way to do this?
View Replies View RelatedI have inherited an ASP application that used MS SQL 7 for a backend DB.The original developer did an excellent job of commenting his work and the applications works fine as is. However, due to licnsing costs,the company is considering moving the application backend to MySQL.
I have looked at the DB structure and it has nothing extreneous other than FOREIGN KEYS. I have heard that MySQL does not support FOREIGN KEYS or Stored procedures.How do I get around the FOREIGN KEY support issue in MySQL?Other than changing my connection strings, if and when I do get the DB end working,do I need to redo the codes?I would like to keep the codes as is and simply redo the interface.In general what should I expect?
The Application was at the initial stages when the company changed course,so they don't mind losing what little data they have in the existing MS SQL 7 db,BUT the table structure must be kept as designed in MS SQL.
is there any way to do a cart blanch dump of a csv file into an MDB file? i.e. specify file, submit, done! that easy?
View Replies View RelatedI have this one short section of code that I need to convert to ASP. Currently it's in PHP and our server does not support that. this code would be used to get someone's email address for a newsletter. Here is the code: PHP Code:
<?php
$var = ', '.$_GET['var'];
$fp = @fopen("file.txt", "a") or die("Couldn't open file.txt for writing! ". $var );
$numBytes = @fwrite($fp, $var) or die("Couldn't write values to file! " .$var );
@fclose($fp);
?>
what is the best way to convert an access .mdb into a mysql .sql file? I found a program but it costs 60$ and thats gay so is there a better way?
View Replies View Related