in mysql i have a float field for bonus points, wich work as currency.
ie 5.12 bonus points = 5.12 discount
i have had the value of 5.12 in the points, and then used 5.12 bonuspoints
however when it has been taken away i am left with this:
-1.14441e-007
as the value in bonuspoints
here is mysql
"UPDATE customers SET bonusPoints=bonusPoints-" &pBonusPoints
The code below is a bit more representative of what I'm doing:
<!--#INCLUDE FILE="Database_Open.asp"--> <% sql ="SELECT * FROM CustomerBase WHERE " & _ "UserName='" & username & "' AND " & _ "SECRETWORD='" & password & "' "
RS.Open Sql, Connection, 3
IF RS.EOF THEN 'redirect code here ELSE RS.Fields("Fullname").value = "Bob" RS.Update %><!--#INCLUDE FILE="Database_Close.asp"--><% Response.Redirect ("Menu_Account.asp") END IF %>
I'm getting an error when I'm retreaving from a "text field" in the database and it has no data in it. I'm using MYSQL version 3.23.58-nt. I have the same script running a different system and I don't get this error. It justs output nothing and continues with the loop.
This has to be an ASP problem when retrieving data from the database. I've change the Field for Message to "varchar(252)" vice "text" in the database and stoped giving me error. But I still need to use the type "text" in the database since my "Message" will be longer then 252 caracter. Code:
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.
I am using a Relational database for my site and i have the following tables:
FIXTURES, GAMEDATES
the fields in FIXTURES are:
GameDate Home Away
(All of the above are numerical fields)
the fields in GAMEDATES are:
DateID(integer) GameDate(#Date Field#)
What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)
The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:
WHERE Fixtures.GameDate<=(Date())
obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.
The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.
Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData
This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?
I have a input form with 5 fields. One of the fields is MajorNo and the other is named Description.
I have a reference table in my MS Access database (tblMajor)that lists the major numbers and their descriptions.
I would like to have the description field in my ASP automatically filled based on the major number entered on the form, so the user will only need to input the major number when submitting to the Access table (tblSalesTotal).
I am trying to pass a hidden field value on a form into another field on the form so that it can then be inserted in the database, to enable me then to reference that number at a later date.
(The hidden value (1 for example) would then automatically get passed to the other input field.)
The code for the text field that allows users to type an number into it for submission to the db is below, but what code do i need within the hidden field to populate this text field below so that users do not have to type the number in? Code:
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
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.
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
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:
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:
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:
I have a not so now small application where I am using an Access database as the backend and ASP. Since the size of the database and the complexity of the app are growing I am looking for a "stronger" database.
I have checked MSSQL but can't afford it, that's why I am thinking to use MySQL instead. Do you have any experience using classic ASP and MySQL, comments, etc.?
I'm working with MySQL both locally and on a live server but empty text (memo) fields error out (Exception) when on PWS but not IIS. -Even if I'm just checking to see if there's a value (if rs("mytxtfield") <> "" then..)
Both are win2k boxes (Pro vs server) with the same drivers (3.51)
I've googled it, but no luck. Has anyone else run into this or is it just me?
However, whenever i run this script, I get the error: [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client
I've used the exact same script on MySQL 5, and it works perfectly. So what must I change to make it work on 4.1.21? it's not possible for me to upgrade the MySQL client.
I'm using PHP. So, i want exporting my Data to Word or Excel. However, PHP can't. And i must write one ASP page to do it. and ASP can connecting to mySQL ?
I am using mysql as my database and which to use a datetime field, for both displaying the data and time and using it to sort the recordsets.
And although when you look at the Db it shows the data and time like this
yyyy-mm-dd hh:mm:ss
however if you simply display the field it displays like this
mm/dd/yyyy hh:mm:ss am (or pm)
I want to sort the data out so that it displays dd/mm/yyyy and there is no time, i can do this but wanted to know if there is a better way of doing it
My problems being I first have to work out if the date is below 10 then us a split function according, then the same with the month, then i have to use a massive if statement, to get it to display in words, and then I have to us the queries before so i can split the year, even if i use to fields in the db to store time and date i would still have the same problems, what is the best way to do this, Plus i may have more than one record to do, will this make a big different in processing my page if i say have 20 records to do.
and just to make sure is the timedate field suitable to sort my record sets out.
I have been using Access and ASP for about one year. I'm getting verty comfortable with this now.
I want to pull some data out of a mySQL database for my ASP pages. It's the database for my PHBBB forum. I'm a bit overwhlemed on where to start. Boy is it difference.
I have made the DB connection and see the tables. As I said it's very different.
Any advice on getting started with mySQL so I can start getting some results?
I m using windows 2003 server, mysql and asp for my web site, I can select, insert, delete data from mysql, but I cannot update, this is the error that I get
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
I'm as the topic notes, having some problems with recieveing decimal values from my database(MySQL). I'm pretty sure its a simple misstake, but since im pretty new to asp-syntaxes, I dont get it.
What I have is a table with a float(30,30) (yes, 30 decimals, its an experiment so I wanto "be safe"). I can take a variable, fill it with a jibberish numeric value say 1.111111111111 and write it in, works like a charm if I check the database manualy, however, I cant get it out!
Whenever I read from that database and into a value, I only get the first 5 decimals and the rest is left out, even if I display the database-value directly I cant get it to work!
If I do response.write MyResult("value") it still displays 1.11111 even if the actual value in the database is 1.1111111111->etc.
I'm coming to the conclusion it isn't possible, because I can't find any reference to it anywhere on the web after a good deal of searching. Let me explain my position, I'm writing an admin area which will access and update a large MySQL database. When the asp code runs the update (about once a week), there will be a high potential for things to go wrong, and as a precautionary measure I wanted to perform a database backup before it ran the database updates. What I wanted to do was similar to the PHPMYADMIN "Export" function, but in ASP, and save the file on the server for me to download at a later date if needed. If I could create the file, I figured that I could save it to a directory with write priveledges on the server using FSO. The problem is actually creating a dump of the structure of all of the tables using an ASP script. I have no idea how PHPMYADMIN manages to do it, but I don't know any PHP whatsoever, and I would far prefer to make it work automatically through the admin area I am scripting in ASP. All the references I could find in the MySQL manual were to creating the backup using telnet access, which we don't have at my host for security reasons, so I wondered if anyone else had come accross this problem before and had a possible solution that could help me [], or whether anyone can say that it definitely is not possible.