I 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 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?
I 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 %>
I 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 );
I 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:
I'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.
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 ?
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 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
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
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
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.
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?
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.
I've got an ActiveX Object that gives me OleColor codes for its graphical components.I need to convert these OleColor codes into RGB codes using JScript or VBScript, becuase I have to using that color inside color style attribute of some HTML components.
Previously I was a ColdFusion expert, but now, d new company that I work with want me to use ASP instead of CFML. And I have no idea how d ASP coded, can u guys help me in this matter? such as what is d main different between ASP vs CFML in coding. Is it very hard to convert from CFML to ASP?
i would like to chnage the script into vb becuase the issue is my daa is in network drive and due to security reason i am unable to store the downloaded data in network drive so i want to develop an vb interface from which this script will run. any link for tutorial or script resources as i am new to vb i want to develop this as an interface like normal software.
I've been charged with coming up with an application that would allow a user to type in a social security number, have a page retrieve the person's information from a SQL Server DB and then convert that information to an XML file. Has anyone had any kind of experience.
I have a standard ASP page that is on our intranet on which I am using the request.servervariables("auth_user") variable to return the domainusername of the user that made the page request. Does anybody know how I can convert the username into the SID (S-1-5-!!!!) equivilant for it? if it is any help it is a WIn2k3 domain.