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 Complete Forum Thread with Replies
Related Forum Messages:
Pulling Records From End Of A Database Or Inserting New Records To The Beginning
I'm trying to pull the last 5 records from my database. <% j=5 rs.MoveLast While ((j>0) AND (NOT rs_article.BOF))%> ''Execute HTML and data insertion here <%rs_article.MovePrevious j=j-1 Wend%> Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic. Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.
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 !
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 !
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 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 !
Using Database Records To Log On
Does anyone know if it's possible to use the records stored in an Access 2002 database to log users into an ASP.net page? I'm trying to code it in vb.net but im not sure how it could be done. Basically I think I need 2 text boxes on the ASP page where the user can enter their name and password. I then somehow need to retrieve the name and password from fields in the database (using ADO.net i think) and compare them with those entered by the user. If they match then I want to load another page, and if not then I want to display a message saying login details are incorrect. Any help on this subject would be much appreciated- the fields i have at the moment are called 'User' and 'Password' in a table called PERSON.
View Replies !
Records To Database
I need to insert many records from one table of one db to another table in another db. I have done this, but I have a problem in the case that if an IDNumber is unique in the destination table. How can I, In the case that record (IDNumber) already exists, to skip that record and continue normally with the rest of records. Not to update that record but to skip that record.
View Replies !
Add Records To Database Problem
I have a form that I want to use to add records to a database. The form and database have only three fields. Trouble is I get a "page cannot be displayed" in IE. The database and the form page are in the same folder. Here's my code:
View Replies !
Printing Database Records
I've got this bit of code that prints out the data from a database to a webpage. Some of the entries in the db are blank whereas others aren't. The code checks if its blank and moves to the next record. If it's not blank it lables it and prints the data stored in the db cell. The prob that it won't print out the db info in the else statement. If I get rid of the if statement completly, it prints every cell including the blank ones. I'm drawing a blank on how to fix it. Could be because I've been looking at it too long.....
View Replies !
Can't Insert Records In My Database..
I am workin on a project at home,asp vbscript website, n im having problems with inserting records into my database .. I am using a dsn-less ADODB connection, but it seems that some kind of security is preventing me from writing in the db.. i can access n retrieve, but NOT WRITE.. ive tried disabling every type of security, still doesnt work..
View Replies !
Know The Number Of Records In A Database
I want to know the number of records in my database when performing a query by sql. I am getting -1 as number of records. <% connectme="DSN=hotel" sqltemp="SELECT Count([All Rooms].Engaged) AS CountOfFREEROOM FROM [All Rooms] GROUP BY [All Rooms].Engaged HAVING ((([All Rooms].Engaged)=False));" set rstemp=Server.CreateObject("adodb.Recordset") rstemp.open sqltemp, connectme, adopenstatic howmanyrecs=rstemp.recordcount response.write howmanyrecs & " records in<br>" & sqltemp rstemp.close set rstemp=nothing %> my project is on an online hotel reservation. I want to have the number of rooms available each time the page loads.
View Replies !
Random Database Records
I'm trying to create a portion of script that would select x (variable) number of random records from a table. in PHP, I could do this pretty simply with a line like, "select * from table order by rand() limit x", but the solutions I've seen so far for asp and access involve things like 40 lines of code, selecting the entire contents of a database, creating temporary tables, etc. Is there any quick and dirty way of doing this?
View Replies !
Inserting Records Into Database
what the best way to update a ms access database from an asp page is.I have a db with 3 different tables,these tables are bound to each other via the relationships. On my asp page,I want to create one page where the user would enter in information and hit submit.The problem I have though is that how do I have only one button that will update information from 3 or more tables all at once?
View Replies !
Displaying All Records In My Database
I am trying to display all the records in my database when I click a button that I made. Can anyone show me how to do that? Right now I have no code for this. I just want a button on my page, so that someone can print out a list of all the records in my database and have it for reference.
View Replies !
Insert Records Into Database
i have learned database connectivity. I am facing some problems in inserting records to database using SQL. Please tell me the way to insert records using SQL. I received error about wrong arguments on following line. Rs.Open Query, DBConn, adOpenStatic, adLockOptimistic where Rs is the RecordSet object, Query contains they SQL String, and DBConn is the Connection to my Microsoft Access database. I easily connected to the database and retrieved records using following command: Rs.Open Query, DBConn, 3
View Replies !
Writing Records From A Database
After this statement, I want to be able to then show the data in the database in a recordor table view for the user. Any ideas? 'Check if username doesn't already exist do while not rs.EOF if rs("username")=Request("Username") then set rs=nothing set conn=nothing Response.Redirect("login.asp?login=createnamefailed") end if rs.MoveNext loop
View Replies !
Updating Records In Database
I'm trying to update records in the database and the script I'm using is giving me an error: Type mismatch /Action_Item/action_items/view_action.asp, line 79 Whis is referring to this line: response.Write("<tr bgcolor=""" & strBgColor & """><td width=""150"">" & lclArray(0,rowCounter) & "</td>" _ & "<td>" & lclArray(1,rowCounter) & "</td>" _ & "<td>" & lclArray(2,rowCounter) & "</td>" _ & "<td>" & lclArray(3,rowCounter) & "</td>" _ & "<td>" & lclArray(4,rowCounter) & "</td>" _ & "<td>" & lclArray(5,rowCounter) & "</td>" _ & "<td>" & lclArray(6,rowCounter) & "</td>" _ & "<td>" & "<a href='edit_action.asp?action_id=" & RS("action_id") & "'>"&"<img src='edit.gif' border="" alt="">"& "</a></td>" ) ....
View Replies !
Database Records Have Been Deleted
I have a web application that simply has 2 text boxes with a start and end date. I have a submit button which triggers the delete from an access database. I use vb.net and asp.net with an access database. I either don't display "record deleted" or always display "record deleted". I tried the textboxchanged, but that doesn't trigger until I hit the submit button. I tried response.redirect, response.write and even tried using a label with the message. Can anyone tell me how to stop the "recode deleted" upon clicking on the textbox or clicking anywhere on the form.
View Replies !
Displaying Records From A Database
I am displaying a table that contains 36 columns and 20-40000 rows.The first row is a header.When i scroll the page down the header disappears(anyways this is a fact).Is there any way in which i can keep the header/first row constant when i scroll the page downwards or sideways for n number of records? I am using Access as the Backend and the front scripting is by ASP and connecting thru ADO.
View Replies !
Inserting Records In Database
I want to insert multiple records in my SQL database. I was wondering if this is the right way to do it: PHP Code: set insertRecords = Server.CreateObject("ADODB.Recordset") insertRecords.ActiveConnection = mlConn For i = 0 To 5 insertRecords.Source = "INSERT INTO Info (Name, Age) VALUES (" & getName & ", 20)" insertRecords.Open() Next
View Replies !
Deleting Records From A Database
If I have an access database with the fields Title, Artist, Description, DiscNo, TrackNo, Price and ID(Autonumber) What would be a single-page script to remove only records where DiscNo= string entered into a text field in a form? Example: I enter into the text field "SC8200" which relates to 18 records in the database. I click submit and all 18 records are deleted. Code:
View Replies !
How To Insert Multiple Records In Database?
how to insert multiple records in database?? i have this problem like i have this one form and there are three fields like the (quantity,unit,item name)..the item that will be inputted will vary, depending on the number of item to be inputted.. Ex. enter the number of item: 3 qty unit item_name 1. 2 pcs pencil 2. 2 pcs glue stick 3. 2 pcs clip (SUMBIT) what should i do in order that these items will be inserted in just one insert statement?
View Replies !
Dynamic Display Of Database Records
I am rewriting from scratch some code done by previous programmer on a glossary for our website. I have a database with three fields, ID, Term, Definition and a table called glossary. I need to be able to display everything to the *same* ASP page. I have already successfully created the db connection and the records display according to the SQL statement, i.e. where Term like 'a%'. What I would like to do is to display each letter of the alphabet dynamically from the Term field as a hyperlink that will display the terms beginning with that letter, i.e. A B C D .... Z The terms would be displayed as hyperlinks and when clicked will display that term and the definition. If A were clicked: Code:
View Replies !
Create Link To Database Records
What I am wanting to do is list the last 10 submissions to a knowledge base and create a link to each one with the question text serving as the visual representation of the link. I have searched the forums for info on how to do this in ASP and have come up empty. I will detail what I have so far. I have a database table called kbase and want to have html table with links to the last 10 things entered. I just can't figure out how to get a dynamic link to point back to the database entry. I may be missing something very simple here but as this is work related my time frame for learning is small at best. Code:
View Replies !
Format Records From Access Database
I have an access db from which I would like to display records in a formatted manner. I can display all the records one after the other on one page no problem, but I would like to display maybe 6 records on one page (3 across, 2 down). I would then need a page break for printing purposes. Displaying all the records on one page would be fine if I can put a page break in so that they print correctly. I currently have it fomatted correctly, but my loop is not working correctly. Instead of different records displaying, I have 6 of the same record displaying, then the next record displaying 6 times, etc. Even if it's better to do this over multiple pages, that would be fine as long as I can print the report with all records by clicking Print only once. Maybe even display the records on multiple pages with next and previous buttons, but when the user clicks print, then it would print a report from access. I hope this all makes sense. Does anyone have any ideas or suggestions or pointers on the best way to do this both for viewing and printing purposes? Code:
View Replies !
|
TRACKER
