Grabbing From MySQL Database In ASP
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.
View Complete Forum Thread with Replies
Related Forum Messages:
Grabbing Values From Database
I was playing around in FrontPage and I noticed that you could insert an ActiveX control for a calendar. I would like to be able to use this to integrate with a database - for example, I would like to be able to click on a day of the month and have the page display all data associated with that date (sort of a select * from database where date = "date_clicked_on")
View Replies !
Database Connection String To MySQL-database On A Different Server
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.
View Replies !
Database Retrieval Mysql And Asp
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.
View Replies !
Query MySQL Database Using ASP.
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.
View Replies !
Call Php/mysql Database From ASP
First 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?
View Replies !
Graphing From A MySQL Database
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 !
Connect To MySQL Database
I'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)?
View Replies !
MySQL Database Records
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.
View Replies !
Export MySql Database
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.
View Replies !
MySQL Database Upload
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..
View Replies !
Restore MySQL Database
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.
View Replies !
Asp.net Connecting To Mysql Database At Ftp Server
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 !
Line Graph From Mysql Database
I 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.
View Replies !
Chat Room Using Mysql Database
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:
View Replies !
How To Check The Return Value Of MySQL Database?
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:
View Replies !
MySQL And Access Database Link
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 !
Search MySQL Database Query
I'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?
View Replies !
Display Tables In MySQL Database
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 !
Connection String For A MySQL Database Needed
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 !
ADO Streams And Binary Data Held In A MySQL Database Blob Field
Has anyone else found a memory leak using ADO streams to access binary data held in a database. I have searched through this forum and have not come across anyone else, so maybe it is just me. The scenario is as follows: Windows 2000 SP3 MDAC 2.7 SP1 IIS5 MySQL 3.23 MyODBC 2.50 If I query the database and do a response.binarywrite everything works fine and no memory leak. eg. response.binarywrite myrecordset("blobfield") If I read the very same BLOB field into a ADOstream I then get a memory leak in DLLHOST.EXE of how big that binary field was. ie If the picture is 140k in size DLLHOST.EXE increases its memory size by 140k. This keeps on happening until DLLHOST.EXE is something like 250 MBytes in size at which point it stops working. Quick restart of the IIS Web service and I get all my memory back. The command I am using to get the data into the ADOstream is picturestream.write myrecordset("blobfield") I have also tried putting the binary data into a variable first before inserting it into the stream: set x=myrecordset("blobfield") picturestream.write x The stream is closed and set to nothing at the end of processing. Everything is cleanly shut down. Through testing I know the memory leak occurs once the data has been written into the stream. The stream is correctly created as type binary. The stream problem I am encountering does not seem to be limited to ASP, I tried it using Visual Basic to create a COM component to do the same job and still got a memory leak. So the questions are: 1. Has anyone come across this before or fixed it? 2. Is there another way of getting binary data out of MySQL, something like the opposite of LoadFile? I have wasted so much time on this problem but cannot find, having searched Microsoft's knowledge base and the rest of the web, any reference to the problem.
View Replies !
Grabbing Info
I am trying to retrieve data from a dropdown listbox in asp using: <%Response.Write + Request.Form("cboBox")%> The problem is that I only retrieve the first value of the option. For example, if my first option was <option value=this that>, I only can retrieve "this". It won't get the second word.
View Replies !
Grabbing Files
Is it possible with classic ASP to have a list of image files in a database, automatically transfer them onto our server from another server and resize their dimensions? We have many images of products that we have to screen grab at the moment from our suppliers' websites and it would be useful to automate this.I think there are tools for ASP.NET to do this but can't find anything to do it with ASP.
View Replies !
Email Grabbing
how or has the resource for graabing a users email address without them knowing? Before I hear all the 'Its not ethical' blurb - I know and my use is legitimate. I am build an e-commerce store and as well as grabbing the users IP at point of sale, i think it would be invaluable to grab a users email address (on top of their registration supplied address - but not always) so that in cases of attempted fraud there is an additional avenue by which we can investigate. The intention is by no means for spam (which I loathe) Anyone know how to do this?
View Replies !
ASP & Grabbing The User's Name
I am testing NT Authentication and have found that the following works Response.Write Request.ServerVariables("LOGON_USER") Response.Write Request.ServerVariables("AUTH_USER") However this gets me "my_domainusername" on both cases. How do you get the users full name and not just the username.
View Replies !
Grabbing Login Name
Intranet application. strLogon= Replace(Request.ServerVariables("LOGON_USER"),"DOMAIN","") The above line is used by several pages on my browser-based app to obtain the Windows login name for the user. Of course, I replaced our domain name with the generic word "DOMAIN" here, but the point is that I am trying to get that name and store it into a variable. It works fine in Production, but not on my dev box, which is on the network and is very similar to the Production server (Same OS, for example). On my dev box, it doesn't return anything, but in Production, it will return jsmith, mjones,etc.
View Replies !
Grabbing Info Out Of An Iframe
I have it inserting a table into an iframe. However I want to pull that table information back out to make changes to it. I am just stumped on how I should go about it. I have the inserting of the table executing through a showmodedialog box. Do I do the same to pull out but how?
View Replies !
ASP Grabbing Windows Username
Anyone know how it is possible for windows to get the name of the user logged in? I know if you do : Request.Servervariables ("AUTH_USER") it displays the username of the person logged in, but is there a way to get the "Full name" of that user in the active directory? Ie, if they log in with the username jsmith, I from that I know there full name is John Smith.
View Replies !
Grabbing Information From Session
I have this site to where people can get access to via a username and passwrod. THere is also a download section in here, but i want to limit the amount of downloads, but i also am covering up where the download is located. So when someone hits download on the page, they get sent to an asp page. This asp page has a response.redirect to download the file. I have stored the peoples username and password in a session. I can "response.write" the infromatino that is in the session, yet i can not assign that information to a variable. Code:
View Replies !
Grabbing Left/right Of A Variable Name
I have several checkboxes named in the following format: chktable_city~20 chktable_state~WI chktable_zipcode~12312 I need to be able to pull the table names and values from each checkbox name (for example, I would need to pull the "table_city" and "20" from the checkbox above). In short, how do I pull out the table_city and 20 from the first example. Since the table names and values vary in size, I can't just do a regular mid, left, right function.
View Replies !
Grabbing Information From A .txt File
I have seen people's ASP scripts which call an external .txt file and compare it to a form's returned information (i.e. a password and login system), and--with my being new to ASP--I couldn't figure out how. What I want to do is write a form's results to a .txt document and retrieve those results via JavaScript, HTML, ASP, PHP, etc.
View Replies !
Grabbing Webpage Data
I need to download content on a webpage once a day and then parse the data. I know how to parse, so once I get the page, I'm ready to go. Is it possible to use something like the filesystemobject to read a webpage instead of filename? If yes, great! How? If no, what can I use to automatically download a webpage that I can then in turn parse?
View Replies !
Grabbing Secure Web Page
I am working on automating a workflow process for my company. Part of the process requires the user to send a snapshot of their benefits from a secure web site to their manager. I am trying to extract the web page using Microsoft.XMLHTTP but am having problems due to user validation which is required to access the benefits web page. There are 2 layers. First, user is required to login with user name and password, then user is redirected to another page that asks for PIN. Only if both authentications pass, the user is considered validated and is redirected to the benefits page. I am not able to through any of the validation pages. What can I do?
View Replies !
Grabbing IP Adres From ASP Webform
As a trainer in a company, I launched a webform asking people to log in before they can access the needed training. Nothing fancy and just there for monitoring who comes in and when. Problem is that some "nice-guys" enter who knows what - because that's fun. Can I counteract this by having the ASP form sending me also the IP address from the PC ? And where do I have to add these lines ? Code:
View Replies !
Grabbing The Maximum Value Of A Field's Contents
I need to evaluate a field's maximum value and then do an if conditional: if rs("havesubP") = true and rs("displaygroup") < MAX then .... whereas MAX represents the biggest value in the records for the displaygroup field (an integer datatype). I get an "Either BOF or EOF is True, or the current record has been deleted.." error if i put any type of comparison number (of course MAX is not a vbscript keyword) that is larger than my largest displaygroup value in the dbase , as I will loop thru all the records once this condition is met.
View Replies !
Grabbing Current Username Via ADSI
My users logon to the Patriot domain, my intranet is on sdsddata01 server. I have a form that people have to click on a dropdown list to pick their name from the list when submitting a form. Is there any way to grab their username via ADSI so I can query it against a database that will get submitted against a form. I have seen a few arcticles regarding this but I couldn't make sense of them. They are already authenticating when they login, so I don't want them to have to do it again once they hit the intranet. Is this possible using ADSI? Will I have to make some permission changes in IIS as well?
View Replies !
Grabbing Special Characters From Another Site
I have a script which grabs headlines from another website. The site I am trying to grab from is in spanish and has those weird characters, but when my script outputs it onto my page, most of those special characters are replaced with question marks. Is there a way to prevent this from happening?
View Replies !
Grabbing File Size Details From A Folder
I have a folder that has a batch of leaflets in it, these are PDF files. In my application I have a list of courses and one of the fields has the name of the file. Is it possible, without automatically having to add them by hand, to grab the file sizes and use them on a page or insert into the relevant db field?
View Replies !
Use Mysql With VB6
I am trying to connect to a Mysql database in the following manner: Dim conn As ADODB.Connection Set conn = New ADODB.Connection Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset conn.CursorLocation = adUseClient conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=myserver;PORT=3306;DATABASE=mydatabase; USER=myusername;PASSWORD=mypassword;OPTION=3;" however I am getting an error: visual basic run-time error microsoft [odbc driver manager] data source name not found and no default driver specified.
View Replies !
Mysql With ASP
Our website is currently developed in ASP/Mysql 4. The dedicated servers on which it is currently hosted arrive at saturation. Here is their configuration: - 1 server PIV 2,8Ghz 1GB RAM with IIS 5 on Windows 2000 - 1 server Bi-xeon 3Ghz, 512 MB with MySQL 4 on Windows 2003 The website makes approximately 10.000.000 of pages seen and 310.000 visits each month (given by an external statistics tool), increasing by 10% each month. The database is approximately 60 MB. I made, I think, most of the optimizations on the database (cache, indexes...). According to our current web hoster, this saturation is due to a bad management of connections between ASP and MySQL and recommends to us: 1/ to put the site on Windows 2003/IIS 6. 2/ to change our database from MySQL to SQL Server. 3/ to change our PIV to a second Bi-xeon.
View Replies !
VB And MySQL
er...i dont know if this belongs in here, so apologies if it shouldnt... Im working on a programme in VB6 that allows people to add news to my site. I was just wondering how can you connect to MySQL with VB and how can you add records
View Replies !
MYSQL And ASP
i need to compare against the database if the user input the correct username and password otherwise to send the user to another page.. but still lets sign in even if the username and password does not match.. here's an example of my code:
View Replies !
MySQL With ASP
I was having trouble with access because it was far too slow and the site kept crashing as too many people were accessing the database at the same time (servers errors because of the lock file kept cropping up). So, I converted the Access Database to mySQL, used the connection string: Conn.Open "DRIVER={MySQL ODBC 3.51 Driver};database=dhsweb;server=localhost;uid=root;password=chadwick;option=3;" And it connects ok. However, I get the following error on the main page: Code:
View Replies !
ASP & Mysql
How can i make ASP read a table and view its content from mysql ? any xamples or a site i can refer to ? 1 more thing .. how to view the Database entries as URL or Links ?
View Replies !
ASP With MySQL
I am trying to create a website in ASP with a database back-end. I am ok when using MS Access, but I have recently read articles saying that Access is no good for dealing with multiple users accessing it at the same time, so I am worried that it will not be able to cope. As an alternative, I am looking at MySQL. I am completely new to MySQL, and even installing it seemed complex. I have installed it to the directory C:mysql, and using 'mysql front' I have managed to create a database with a few tables.The database is in the 'data' subdirectory along with the mysql database. Code:
View Replies !
|
TRACKER
