Now i got problem in my ASP page using VBScript that is implemented for IP Phone Service.I am trying to do directory service in IP Phone.So user key in the first name or last name.
According to user input, it will go n look for the name in MySQL database.If the name is not found,it will return the error.My VBscript programming is bad.I cant check it out how i check the return for Record set from database. Code:
I have 3 checkboxes with the same name and on submitting form it returns the result like this 1,2,3. My question is how can I Retain the checked checkboxes checked, if we return from another page to this page.
I usually return the value using session and it work fine on radiobuttons and dropdown , but this is the first time I am dealing with multiple checkboxes here, so I dont know what am I doing wrong.
Here is what I am doing:
<input type="checkbox" name="chkName" value="1" <%If Session("chkName")="1" Then Response.Write("checked")%>> 1
<input type="checkbox" name="chkName" value="2" <%If Session("chkName")="2" Then Response.Write("checked")%>> 2
<input type="checkbox" name="chkName" value="3" <%If Session("chkName")="3" Then Response.Write("checked")%>>3
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
I am running an sql statement to retrieve the values entered for a particular month. If nothing was entered by a particular user for a particular month, it will return null. However, I need a null return to be set to 0.
The variable "returnValue" holds the (you guessed it) returned value. I've tried everything I can think of, and no statement will turn the null value into a zero. Code:
how to replace carriage return upon extracting text from Access file.
However I think it will be smarter to do it before (during) inserting text into acess file.
It might be primitive question, but I started my ASP learning just last week and many things are confusing me on this stage.
QUESTION:
What should I change in my ASP file code (file inserted data from the HTML form file into database file) to replace all carriage returns and line brakes during inserting text into field GuestSory? Code:
I have an sql statement like this executed with asp and mysql.
select * from table1, table2, table3
How can I read a specific field from a table when tables have same fieldnames.
So for example table1 and table2 have both a field named content.
What I would like to do is:
contenttable1 = recordset("table1.content")
contenttable2 = recordset("table2.content")
But then I get an error like item not found in recordset.
If i do this it works but i don't know which field I read from:
contenttable? = recordset("content")
I know that it works with Access but I can't get it working with MySQL.
I wish draw data from a MySQL Database using ASP.
The Code I have so far:
<%
dim adoConn, adoRS
set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "driver={SQL Server};server=SERVER-WEB;database=testing;uid=products;pwd=starmart"
adoRS.ActiveConnection = adoConn
%>
and in the asp page code:
116. <%=rsDaySummary.fields("PageViews")%>
This is obviously wrong as it returns this error:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/stats.asp, line 116
Any pointers would be appreciated.
Can someone tell me how to access a MySQL database using ASP?
View Replies View RelatedFirst I'll answer "why". Because, while SQL Server is available, it is also
"expensive". MySQL is CHEAP and a lot more robust than Access.
Is there a way to add, update, retrieve, and delete data from a MySQL DB via
php (or ASP for that matter) back into ASP? Could someone create a basic
script to look at so I could see how?
I hope there is a way to do this. Wouldn't it be advantageous for MS to do
this or to make it easy to do so to be more competitive?
I have seen several free graphing solutions using PHP, but does anyone know of something in ASP? I am wanting to create some simple bar, line, and pie graphs from a mySQL database. Everything I've found is in PHP (which I don't know). Is there an ASP solution?
View Replies View RelatedI've tried a couple of strings, but it can't connect to my database.What's the connection string?
View Replies View RelatedI'm a PHP developer and i've been asked to do some development for a site which is on a web server which only supports ASP. I had planned to have a bash at writing an ASP program (first time) on this server which will interact with a MySQL database on another web server (my company's web space).
Would this be possible, or should I try and set up the database on the same server as the ASP pages (this may cost money, which is why i'm hoping the first option will be possible)?
i post a while back on how to page thru database records. i dont really understand the ASPFAQ one. Its not well commented. This is how i learn anything, is if its commented on what does what.
Can someone please help me. i have a datbase of about 90 records so far, that i would like to page thru.
I have a client that wants to export their database to excel from their admin section on their website.
Is it possible to export a MySql database using asp code?If so is there sample code that i can look at? I haven't found anything on the net that works or is usefull in any way.
Code:
Dim sConnection
sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=" "; UID="";PASSWORD=""; OPTION=3"
using this code(connection), how can i upload the mySQL Database? you see, i can't install mySQL online..
I'm doing a website in PHP/MySQL but its an IIS server - THUS no sendmail. I've used CDONTS to send email in ASP before but this time its a little different
I have a MySQL table called 'emails' in a database called 'db'. The table has Key IDs from 1 to about 50 that correspond with different email addresses. I want to use CDONTS to Grab the email addresses from the MySQL database one by one and in 15 second intervals send out the same email to each address.
I know this sounds a bit 'spammy', but it's a band website with a mailing list. Only about 50 or so entries. I'm trying to set up a mailing list manager and the only missing piece is this damn emailing script.
I am moving my site from one host to another. I got all the scripts moved over but now I need to import my MySQL database. My previous host has a tool to create a .sql database dump. However, my current host limits the size a database dump can be for using phpMySQL to import the database.
Is there any way I can FTP the .sql file to the webserver and run an ASP script that points to that file and executes all the commands? The .sql is 300,000 lines.
currently i m working on a web-based project using asp.net and mysql database. i using MySQL Connector/Net to connect my asp.net page to the to MySQL database server. My database is stored in the ftp server. In short, i m trying to connect my asp.net page to the ftp database server. Code:
View Replies View RelatedI have an InputBox in VBScript for you to enter your email, I now need it to write to my database. I am either getting a type MisMatch error or it is writing an empty string...
View Replies View RelatedI have a very simple database called "Tests" with a table called "Results" and the followint fields
ID = Auto
Test_Date = Date
Test = Text
Results = Int(11)
I would like to have three line graphs based on the type of test. Line graph one where test = abc, the next graph would be where test = lmn and the third graph where test = xyz. The graph would show the past 12 months data.
I am working on developing a chat room using mysql database. the chat room has two frames one for the display text and the second frame for submit text from the user.
the two frames are:
display.asp
send.asp
what I need help with is when the user send a message how can I update the data with the new entry. Code:
Is it possible to call fields from a MySQL Database and an Access Database on the same asp web page? If so, can someone please point me in the direction of a good guide/article/post on how to do this.
View Replies View RelatedHow to secure MySQL Data with encript, any data to encript have ''' and MySQL send Error, how to protect ASP Data o encript the code ?
View Replies View RelatedI'm creating a database search page and the table I want to search has fields linked to other tables in the database. For example, the job table has a number of fields, 2 of which are area and job type which are tables in the database. My search page has option for searching by job title, job type and job area (via dynamic drop-down).
Do I need to create a recordset for each referenced for the dynamic drop-downs to work?
i need to display all my tables from the mySQL database in a table on an ASP/Javascript page, each as a link, so that when clicked, it wil open the selected table for editing. unable to do it as dreamweaver MX is not accepting 'show tables' as a valid query. how can i go about doing this? i'm relatively new to ASP, working on it for only 2 months now.
View Replies View Relatedhow asp script when I want to check two different tables in database if data in table in different
example:
in table sent_sms where status sent but no receive_sms, i want insert status in status "Not OK"
I am struggling to store an image path to a mysql database and in the process copy the image from one folder to the folder I would like it to be copied to.
My code for the inserting the image path and data into the mysql db is below: ....
I'm trying to get asp to conect to a MySQL database, I've tried copying a few examples online that I found [there doesn't seem to be many!!] and I always get a 500 error with the code below. what am i doing wrong? any examples of a working connection string anyone could show me would be fantastic.
View Replies View Relatedhow to create a shopping cart by using mysql as database?
View Replies View Relatedi am getting a prob. in database id is a autonumber .i want to update value after retriving the va,lue from database .that is going on i mean retriving valuue from database but not update. Code:
View Replies View RelatedI have setup a database for user to upload product image and it name and desciption. Since there is no product upload by user, it will display this error:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/i-Metz/iMetzAdminADs.asp, line 295
Therefore i wrote this script to counter the error:
there is any way i can check if the database Exists. I mean from the code side. I dont want it to throw me any error thats the reason.
View Replies View RelatedI have to check wether the database connection is opened or not.I am using ASP with sql server database.
I can open connection and do all the transaction with the database,when multiple users are connected to that same sql server instance,i got an error like sql server not exist or access denide.So i want to check my status of the connection.