Query / MySQL / Access
I've got a query that works fine when used in mySQL but completely fails
when I try to apply it to MS Access, weird thing is that it is just a copy
of a stored procedure that works fine in the same copy (with the
Request.QueryString replaced by a fixed value) ! Any explaination would be
great, ID is a number BTW :
SELECT page_title,ID,page_content FROM content WHERE ID='" &
Request.QueryString("ID") & "' '
Had a look at aspfaq.com but couldn't find anything that applys.
View Replies
ADVERTISEMENT
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
View Related
I have a Fedora Core 4 server with cPanel which is my master server shall I say. And 2 days ago, cPanel did an update which brutally murdered my MySQL 4.0.25 on the system, so I was forced to upgrade to 4.1.18. So we did that, and all is working now...
Now, my business has satelite servers that revolve around the master server. It allows people to remotely start and stop services on those satelites, and it uses ASP to remotely connect from the satelite, to the MySQL database on the master server to retrieve information regarding the users.
So yesterday, after the upgrade, my satelites seemingly connect to the MySQL server (it does not give an error), but it does not perform a correct query, thus no users on the network can start or stop their services. It just says "Invalid user or server". Now, the MySQL connection is working, because I have other software that authenticates thru the Master Server MySQL database that is working perfectly... I just think it is something wrong with the code on this Activ Serv... I had the program custom written about 2 years ago..
I have tried upgrading the MyODBC driver from 3.51.10 to 3.51.12 and that did nothing to help.
I have the entire code which is right here. Of course it uses a executable on the server to start/stop services and collect process ID information. But the queries are not working correctly so the executable never even runs... Code:
View Replies
View Related
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
View Related
Ok so after ironing the bumps out of connecting to my MySQL database in ASP, I now want to run a query. So far it's working perfectly, BUT, it only returns with one result. Code:
View Replies
View Related
My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
View Replies
View Related
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:
View Replies
View Related
According to �Beginning Active Server Pages 3.0� from Wrox, Data Source Names
�are a largely outdated method of specifying connection details, mainly because they use ODBC drivers instead of OLE-DB providers to handle the data. We include them here only because you may come across DSNs when working with legacy systems.�
Which is better: using ODBC with a mySql database or not using ODBC with this type of database?
Also, based on the model below, how do you create a connection to a mySql database (using myODBC and not using myODBC)? Please note that I will be testing the database on my PC but it will also be used on a website. Code:
View Replies
View Related
I have my site hosted with uplinkearth.com which supports MySQL; they say: "We have set up your MySQL database for you." (i.e. it is ready for me to work on it). My site is a classifieds page that is small(not much code at all) but gets a lot of traffic and I want to switch from Access to MySQL.
I know that some conventions are different, but on a more general note, what is the process of conversion? I have someone who will be working with the ASP code, I just need to know the basic procedure, i.e. how do I make changes to my database, etc. How will it be different than working with Access? I've heard "MySQL Front" is a good program to edit the DB.
View Replies
View Related
Not that much experience working with .asp, but I have managed to create a project.
This project currently has a DB in Access.
I'm moving it over to MySql.
Was able to ODBC import it and all data seems gtg.
Uploaded a test folder, and modified my connection so I can test the MySQL database before I change over. Code:
View Replies
View Related
other then the connection string are there any diffrences when using mysql and not access?
i know mysql has more powerful tools but will the querying and searching and updating be the same syntax in asp?
View Replies
View Related
I don't hv access to install ODBC drivers on the server so trying to use SqlConnection to connect to MySQL but so far no luck.
Been trying:
SqlConnection conn = new SqlConnection(
"Data Source=(66.79.180.140);Database
=testdb;User ID=test;Password=testing");
conn.Open();
And it fails on the conn.Open() call with the exception:
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
View Replies
View Related
I am using ASP/MS ACCESS to see how I can query the same database, via 2 formfields.
{name: - search}Textfield 1: - Search by Category
AND/OR By
{name: - searchT}Textfield 2: - Location
Currently,
strSearchwords = Trim(Request.QueryString("search")); where "search" is the name of Textfield1
Which is fine, but how can I set it so that on Submit, the string from search, and searchT are somehow joined together into one string?
View Replies
View Related
I have always used PHP and MySQL to do anything database related on the web, however I find myself in a new situation. I've been handed the daunting task of creating a (relatively) simple, partially database driven website for my company's intranet.
The one problem I have is that all of our servers are Windows 2000 based because all of the in-house software we have works off of SQL Server... and I've never touched a windows based server, SQL Server, or ASP in my life.
Searching through the forums, I've been able to find a few ASP tutorial sites, but everything I've found seems to be either all technical info and no basics or a basic tutorial written for people who are already familiar with Visual Basic, C, or another type of windows programming 'thing'.
View Replies
View Related
Not that much experience working with .asp, but I have managed to create a project.
This project currently has a DB in Access.
I'm moving it over to MySql.
Was able to ODBC import it and all data seems gtg.
Uploaded a test folder, and modified my connection so I can test the MySQL database before I change over.
I try running the pages, and have been making changes to the code as I see errors come up.
All was moving forward until now.. where I just keep getting 500 errors, and can't get it to tell me what's wrong.
I use Option Explicit, and all my variables are posted.
Is there any other code I can put into my pages so that it will not just generate a 500 message when there is something wrong?
Or any Software programs I can get which will help me troubleshoot my code for MySQL?
View Replies
View Related
I've been using URL asp shopping cart (free version) for a while with an access database and it worked perfectly.
My store is very popular now (more than 200 simultaneous users) and I need to migrate to a professional database. Comersus is compatible with SQL Server and mySQL. Which one do you recommend? My idea was to use mySQL since in that case I can purchase Power Pack Medium ($239) instead of Premium (.$370)
View Replies
View Related
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 Related
I have ASP project uses Access DB .. I need to convert the site into Mysql. But I keep getting some Runtime Error ( Mismatch ) and I don't know what the problem .. Code:
View Replies
View Related
having issues submitting dates to a mysql db, ive converted the database from access to mysql and im having issues submitting dates. this is what i have when submitting to access
Code:
View Replies
View Related
im converting my access db to a mysql db.
having issues reading int (true/false) values out of the mysql db.
this is a snippet of the asp script Code:
If rslogin("Master_account") = True Then
Response.Write("master_account=true")
else
Response.Write("master_account=false")
in the access db the master account field was a true/false ( yes/no) field. in mysql its an int filed with a value of 0 or 1. Code:
View Replies
View Related
What is this all about? Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join
SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId
FROM (tblArtists
INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId)
LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId
ORDER BY surName ASC, firstName ASC
Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?
View Replies
View Related
I'm trying to run an access query with one parameter that is a string. I can call a query that has no parameters. I can also call a query that has one parameter that is an integer. But the one that has a string parameter isn't working.
Here is the code:
[VBS]set rs = conn.execute("getArtists '" & ltr & "'")[/VBS]
I've tried using a command object and it did the same thing. Is there any other way I can get my query to return the records. Running it in access works.
View Replies
View Related
I have a Acces query which creates a table using manipulated data from another table. I want my asp page to run this query after doing an update to the database.
View Replies
View Related
Is it possible to write an SQL statement that reads from an Access Query instead of an Access Table. If so is the syntax the same as for reading a Table.
View Replies
View Related
How can you use ASP code to execute an Access query. I want to run the query to then display updated data on the webpage.
View Replies
View Related
Where I found this?
Like this:
SELECT
SELECT TOP N
INTO
FROM
WHERE
GROUP BY
HAVING
UNION (ALL)
ORDER BY
WITH OWNERACCESS
( http://msdn.microsoft.com/library/e.../access2sql.asp )
But with explanations (usage) and samples...
View Replies
View Related
I have a field called store, I have more than 1 row with the same store name in the store field.
I need to coolect all the stores from the store field, remove any duplicates, like I might have buy.com twice and only need it to show once in the drop down. And sort ascending (by store name).
Summary.
Database is called: tracker
The table (and the only table) is called merchants
I only want to pull data from the field store, remove duplicate store names, sort ascending.
I can figure out how to plug the required htm around the asp code, to auto populate the drop down.
View Replies
View Related
I'm using odbc and Classic ASP and I want to read the sql content of a query in an access database. ANyone have any clues?
View Replies
View Related
I am trying to query an Access database using the like operation; however, when I test the query in the browser all records from the database are displayed. Here is my code:
View Replies
View Related
I want to do a running total query , here is what i want :
I want the running total like this:
View Replies
View Related
I'm attempting to limit a query which is being ordered by a date field to 10 records. The date field contains duplicate values, which are sorted from most recent, back.
However their suggestion of sorting by a secondary field is not providing acceptable results (it returns all the rows in the database). Does anyone have any suggestions of another way around this?
View Replies
View Related
What is the best way to create new queries and/or modify existing tables within an online access database. At the moment, I am periodically downloading the db and making alterations. But, I have heard others on the list say they use a query analayzer built on
a <form> where they execute SQL statements. Is this the correct way to go?
View Replies
View Related
I have the following query:
Update properties set Last_Change=#8-Mar-2006# Where properties.fdref='h3c000';
which works fine when I run it on my desktop under MS Access, but when I run it as an ASP page, I get the following error message:
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
I am using the same database bot online and offline so field names etc are exactly the same.
View Replies
View Related