Mysql In Asp Syntax Prob

i got this line before:

mySQLde="UPDATE crmagents SET online=NULL WHERE online < DATE_ADD(LOCALTIME(),INTERVAL -20 MINUTE)"
connasa.execute(mySQLde)

it working perfectly! it was nulling all the records older than 20min

but i needed to add the nulling opration of the fields on the second table than i wrote this Code:

View Replies


ADVERTISEMENT

Mysql Syntax Problem

I have an ASP aplication (which isn't written by me), connected to an Access Database, but recently they asked me to change it to MySQL.

Although i'm a newbie in this matters of dinamic pages, I was able to configure "almost" all the ASP programation to work correctly with Mysql. But i have a single problem which is: Code:

View Replies View Related

SELECT Syntax In MySQL

Could anybody tell how this query statement looks like in MySQL syntax?

SELECT (Left(TAB1.Field1,InStr(TAB1.Field1,"-")-1)

I have a field containing Styles such as 1010-10, 1010-20, 5050-40, LS7856-10, 7856, 9090. I need select and group them by the part which is before "-". In Access it was pretty easy but in MySQL syntax error appears.

View Replies View Related

Date Prob

In Sa the date format is dd/mm/yy. in sql server the format the format
is mm/dd/yy.

What code can be used to chnge the format to the SA date format
eithout chnging sql servers regional settings?

View Replies View Related

Pdf Link Prob

(1)I posted this in general but didnt get anywhere. Then I recalled seeing something recently on the web on an ASP site but cannot recall where.

(2)I have a list of pdf files avaiable for the user to view. When they click the pdf link, the pdf file opens. How can I make the link be a 'save' link? ie, when they click the link, windows treats it as a file to 'save as' etc...

What I vaguely recall on the ASP site was: 'How to hide the path of a download file by using an ASP redirect page'. I was wondering if anyone knows this method, and if they do, would it solve my problem in (2)

View Replies View Related

Login Prob

when the user enters his userid and password i want to
check the password from the table..

if any user with the userID that is entered exists i want
to find the correspoding password for him else i want to
throw an error saying no such user exists..

i know how to access the MS Access table and stuff..but
now what i want to do is to take the userid and see if
there is any userid such as the one existing, and if there
is i want to take out the password for that user ID..

what i am trying to do is as below.

The prob is, once i get the data in the dataset, how do i
take out the password?? Code:

View Replies View Related

MailScript Prob

i'm making a script that will mail all contacts within a database, basically it just loops through all the mail addys. but i'm getting this error: Code:

View Replies View Related

ASP Date Prob;

How can I fix the date and time of the next coming Monday in this format (8/28/2007 10:10:00 AM).

View Replies View Related

Authentication Prob.

I have a folder on my website that has 'anonymous access' and 'basic authentication' disabled, and requires 'intergrated Windows authentication'. This used to work fine, but all of a sudden it won't let me in! .

The login box appears, I have checked the username, password and domain are fine (I can still log directly in to the server with them) but I can't get access.and after I've tried 3 times I just get redirected to the: 'You are not authorized to view this page' page. Same thing happens even if I try usingbasic authentication.Does anyone know why this is happening?

View Replies View Related

Url Length Prob

I have a webpage with a form and i am saving the webpage using name value pairs. So i can give the users a link which they can click on and the form will open up prepopulated.

The problem i am having is that these forms can get exteremely long (hence the prepopulation facility) e.g test.asp?name=value?name1=value1?name2=value2

is there any way to increase the url in a browser or if you know of any other way i can accomplish this id appreciate ure feedback more detail regarding the above: I am allowing useers to save their forms with the data, also save multiple versions of the form (same form with diff data).

View Replies View Related

Querystring Prob

does any one know if you can send more than one variable via a querystring.

View Replies View Related

Drop Down List Prob~

Im having a form for user to enter fields. One of the requirements is to enter the school name. To overcome a difficult and long drop down list. How would like to let the user select from a "state" drop down list first, and it automatically will change the drop down list of the "school" under the selected state. How do I do that?

View Replies View Related

Shopping Cart Prob

I am creating a very simple cart kind of thing but have encountered an error and don't know what to do about it. This is the error I get

Microsoft VBScript runtime (0x800A000D)
Type mismatch: '[string: ""]'
/pinsys/Goods_receive/cart.asp, line 167

This is the line Code:

FOR i = 0 TO UBOUND( localCart, 2 )
IF localCart( CARTPID, i ) <> "" THEN
orderTotal = orderTotal + ( localCart( CARTPPRICE, i ) * localCart( CARTPQUANTITY, i ) )

View Replies View Related

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 View Related

C# Asp Mysql

How do you add data to the tables from asp website using C# (for mysql)

View Replies View Related

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 View Related

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 View Related

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 View Related

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 View Related

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 View Related

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 View Related

Using MySQL

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.?

View Replies View Related

IIS Vs PWS W/ MySQL

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?

View Replies View Related

ASP And MySQL 4.1.21

I'm trying to connect to a MySql datbase, which is version 4.1.21. This is the connectionstring I am using: Code:

strConnectionhg = "driver={MySQL ODBC 3.51 Driver};server=67.159.10.***;uid=dan_anope;"
strConnectionhg = strConnectionhg & "pwd=******;database=dan_anope"

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.

View Replies View Related

ASP And MySQL

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 ?

View Replies View Related

Mysql

asp is compatible with MySQL as a backend? Further can anyone also help provide me user groups for MySQL? Is PHP a better option than ASP?

View Replies View Related

Where NOT IN ( ) Syntax

Can I use this syntax

Where NOT IN (".....)

in a situation I don't want to select items in the list.

If not what other ways can do that.

View Replies View Related

Syntax Help

I'm just trying to display a user's FIRST name and the FIRST INITIAL of the last name on my asp web page.
This works to displays their "firstName" and "lastName":


Code:
<%=oUsers("firstName")%>&nbsp;<%=oUsers("lastName")%>
But I get a variety of vbscript or asp syntax errors when I try to trim the "lastName" using something like


Code:
<%=oUsers("firstName")%>&nbsp;<%=oUsers(replace(left("lastName",1))%>
How do get this simple task done?

(If it makes any difference, the whole thing is inside html <td></td> tags as part of a table)

View Replies View Related

SQL Syntax

I can't see to find where the syntax is wrong because I can do the query just fine in access but my asp page gets this error

Microsoft JET Database Engine error '80040e14'

Syntax error in INSERT INTO statement.

Here is what the insert looks like when I print it out in the page

INSERT INTO tblusers (username,password,[Timestamp],email) VALUES('testuser', 'c4ca4238a0b923820dcc509a6f75849b', '10/16/2004', 'me@home.com')

Here is the code:

View Replies View Related

SQL Syntax

I am trying to query a database for 2 conditions but I can't get the query to work.
Can anybody see a problem with this line of code?Code:

strQuery="SELECT Count(*) AS intTotal FROM tbl_artists WHERE fld_artist_name = '" & strReqname & "'" "AND fld_user_id ='"& strUsername & "'",objConn,,,adCMDText

objRS.Open strQuery,objConn,,,adCMDText

numRecords = objRS("intTotal")

View Replies View Related

SQL Syntax

I have a textarea and have named it category_One.

I have sent the data in this form on using the POST method

contents_category_One = Request.Form("category_One")

I have then used the following sql statement

sql = "INSERT INTO tableName(Category_One) VALUES ('"& contents_category_One &"');"

If someone inserts ' in the text box, this value is causing a syntax error in the sql statement.

View Replies View Related

SQL Syntax

The WHERE part of my select needs to pull out where the date column is empty. If there isn't a date, it shows NULL in the database (SQL7)."WHERE eligibility_dt <> NULL" doesn't work. what am i forgetting?

View Replies View Related

ASP Syntax

I need help with ASP. when i post data to the database, do the records in my form need to be in the same amount as the database records?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved