Convert Function
reg_date = "CONVERT(DATETIME, '" & reg_date & "', 102)"
i dont know what the reg_date change to ...any function ?
reg_date = "CONVERT(DATETIME, '" & reg_date & "', 102)"
i dont know what the reg_date change to ...any function ?
How do I convert one DataType to other using the CType Function?
and can you show some examples......
What's the difference between private and public functions in ASP? When should I use either?
I am using a simple guestbook /portal and i want script to send mail to the thread owner when someone reply his message.
this is the send message code ....
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 RelatedI have this code that I need to convert to php. I tried using the client-side online conversion but it didn't work to well. This is an easy script and I can mostly do it myself except the date functions. Code:
View Replies View RelatedI'm in charge of setting up and tracking advertising for my company. Since Google can be set up to automatically mail out a report every day (I also use Overture) I would like to write a program that would automatically grab the .csv file from a specified location, grab the data and convert it to an Access .mdb file.
The idea is I'd like to automate the process of downloading reports from these two sources, transfering them to a database, and mailing the new db file out. I'm not really sure if this is possible or not, since I don't know how to grab a column from a .csv file and convert it into a field in a table.
Can I define a function inside a function. e.g;
function abc()
function xyz()
....some code.....
End Function
End Function
I googled this but can't find any related topic.
I want to use the instr function, but return results from it depending on surtain functions, I can't realy explain so I'll show my example:
I have a string in wich some word I want to find might be in diffrent Capital Letters order, I want the Instr function to return all the values of the place of that word (avcourse I'll run a for and increase the starting point of the Instr func until it returns 0). The instinct thought is to use the Lcase or the Ucase functions, but in this case I don't know how to use them. In the same Idea I wanted to use the Instr Func with the trim Func, But Its realy the same principle if I just understood how to do so.
i did a application here it works off line and for online also
when i sold it for offline there is a problem with ASP code
any idea for changing asp files to dll file
i 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 ?
Is there a way to convert a page of html to rtf ?
View Replies View Relatedim 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 had select the data from the database. The null value are returned.
How can i convert the null value to integer so that i can add some value for it??
Actually i try to use both of this statement but there's nothing come out...when i try to selecte the data in the database, the null value are returned
if rs("max_id") = "NULL" then
id_no = 1
response.write "id_no = " &id_no& "<br>"
end if
and
if rs("max_id") = "" then
id_no = 1
response.write "id_no = " &id_no& "<br>"
end if
How do you change the DateDiff function to give only 2 digits?
[CODE]
ltOffHours = Abs(DateDiff("h", CDate(rsRecs("EndTime")), CDate(rsRecs("StartTime"))))
ltOffMinutes = Abs(DateDiff("n", CDate(rsRecs("EndTime")), CDate(rsRecs("StartTime"))))
ltOffTime = ltOffHours & ":" & ltOffMinutes
It gives me I.E. 4:345, I need have it read only 4:34 minutes. anyone know how to do this?
I am setting up a website similar to http://www.4mobilefun.com/mobile-gam...ware/index.asp.
For search engine reasons I need the website to html format. The website will be given to me in ASP format. For example:
I want http://www.4mobilefun.com/mobile-gam...ware/index.asp to be http://www.4mobilefun.com/mobile-gam...are/index.html
and
http://www.4mobilefun.com/mobile-gam...ake=nokia+7250
to be
http://www.4mobilefun.com/mobile-gam...nokia7250.html
and
http://www.4mobilefun.com/mmsend.asp...es&object=game
to be
http://www.4mobilefun.com/mobile-gam...cksnbabes.html
Is there an easy way of doing this?
IŽam using a DB2 db.
I doing a Update query and gets this error
A value is not compatible with the data type of its assignment target. Target name is "POSTCODE". SQLSTATE=42821
this is a bit of my code
vPOSTCODEn= "POSTCODE" & myRs.Fields("SAID")
vPOSTCODE= CInt(request.form(vPOSTCODEn)) // Here IŽam doing the convert from a string to a Integer
SQL="UPDATE TEST.Supplier SET SALECOMPANY= '" & vSALECOMPANY &"', SALECOMPANYNUMBER='" & vSALECOMPANYNUMBER & "', ADRESS='" & vADRESS & "', POSTCODE = " & vPOSTCODE &" , CITY = '" & vCITY & "',COUNTRY = '" & vCOUNTRY & "' WHERE SAID=" & vSAID
How to convert the following html to asp page using response.write?
<td align="right"><Font class=content4><%=ars.Fields("REVENUE")%></td>
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
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 need to know a method that how can I convert html document (asp generated html text report) into a PDF document. Is anybody has a good tool for this, or anybody can tell me where I can get such tool. There are lot of tools which are available for sale, and I'm looking for a free product.
View Replies View RelatedI am used to doing this in VBScript. But I am not able to get this to work in JScript.
My code simply tries to add 1 a variable which holds a char and parse into an int. But instead of a value of 2 for an addition for 1+1, I see 11.
sCount = Request.Querystring("Count");
//sCount outputs a value of 1
sNextCount = parseInt(sCount + 1);
Response.Write (sNextCount);
//outputs 11 instead of 2
Is parseInt wrong?
I am using Response.ContentType = "application/msword" to show my asp page in the word document which works fine. Once it is in word is seems to be ignoring my styles so is there something that I need to do extra? And one more thing: Is it possible to set up a header and footer for each page, where the header would be generated dynamically from the ASP page, in this case a Clients Name?
View Replies View Relatedi 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 do I convert an nvarchar field to smalldatetime format?
My nvarcharfield (saledatetext) is in the format YYYY-MM-DD.
I want to convert is to smalldatetime (field: saledate)