ternet access, what are the chances that
they'll view your CD-ROM in the first place? If you're trying to sell
websites to businesses who are NOT net savvy, a flashy CD-ROM may not do
the job... Instead, pictures, charts, and graphs may do the job better.
--
Michael She : [EMAIL PRO
ks, Michael
I am not sure it's mysql's problem or myODBC351's problem
But, what I am sure is
rs2("data").Value = Now
is working fine in mysql323 + myodbc351
but, err in mysql407 + myodbc351
the err msg in msgbox: Query-based update failed because the row to upd
nk you should remove the ' from the ID in your SQL query. If
the ID field is not numeric it should be
"...WHERE ID = '" & ID & "'"
If it is numeric it should be
"...WHERE ID = " & ID
Hth
Freddie
-Ursprüngliche Nachricht-
Von: Mich
even after
deleting, so I changed it by myself.
Don't use the PK for numbering. Instead, in PHP, ASP, etc, just use a
counter when looping through your guestbook entries and label them 1, 2, 3,
etc.
BTW, does MySQL have a RowNumber function?
--
Michael She : [EMAIL PROTECT
ember 2002 12:02
An: [EMAIL PROTECTED]; Michael She
Cc: [EMAIL PROTECTED]
Betreff: Re: ADO Error '800a01fb'
Hi,
This is an aoutomation error and is possible to be raised because you
use CreateObject instead of using object directly.
Regards,
Gelu
___
or msg... tks.
Chiang
- Original Message -----
From: "jumpmaster" <[EMAIL PROTECTED]>
To: "Michael She" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, December 29, 2002 7:39 AM
Subject: RE: ADO Error '800a01fb&
"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.open strConn
set rs = server.createobject("adodb.recordset")
strSQL = "SELECT * FROM IMAGES WHERE `ID` = " & ID
rs.open strSQL, objConn, 3,1,1
Nothing out of the ordinary... anyone know why I'm getti
What language are you using to pull the data? ASP? PHP? VB?
At 11:23 PM 12/26/2002 -0800, tan tan wrote:
Hi,
Is anyone know how to view image that is stored in
mysql as binary format to
a browser ?
Thank you.
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage
on. I found in the document something
saying that timestamp fields are precise, like unix time, but I don't
want it to be changing on update. Does anyone has some experience with
it?
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.bi
Thanks for the link!
I was having some trouble figuring what keywords to search under ; )
At 11:43 PM 12/22/2002 -0800, Jeremy Zawodny you wrote:
On Mon, Dec 23, 2002 at 02:41:03AM -0500, Michael She wrote:
> Hi,
>
> Is the \ character a delimited in MySQL? I noticed in text inser
Hi,
Is the \ character a delimited in MySQL? I noticed in text inserts I have
to double slash even if it is enclosed in single quotes. I find this
behaviour a bit odd.
Are there other delimited characters I should be aware of?
Thanks.
--
Michael She : [EMAIL PROTECTED]
Mobile : (519
objConn
rs.PageSize = 1
rs.absolutepage = LocationCount <-- This line dies with the error message:
Current Recordset does not support bookmarks. This may be a limitation of
the provider or of the selected cursortype.
If I do not use a Client side cursor.
--
Michael She : [EMAIL PROTECTED]
Mobile
9 digits to the left
of the decimal point. :-)
How did you guess! This behaviour is why I asked the question in the
first
place. Why does it get clipped for a 10 digit number. Without the
decimal
value I believe it inserts correctly, but with the 2 decimal places it get
clipped...
--
Mic
imal point and, for negative numbers, the `-' sign, are not counted
in M (but space for these is reserved)"
The manual states that the negative sign and decimal points are not counted
in M. By this wording, it should be 10 numeric digits.
I guess it's bad wording... or just an inco
At 09:18 PM 12/20/2002 -0500, Michael She wrote:
The value's been clipped to the upper end of the range.
>>Your next question should be why that value has 9 digits to the left
>>of the decimal point. :-)
>
>
>How did you guess! This behaviour is why I asked the question
oes, and how it operates. Over time, MySQL will gain the confidence
and accept of lay-people and turn into gravity of sorts.
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/
---
At 06:17 PM 12/20/2002 -0600, Paul DuBois wrote:
At 17:21 -0500 12/20/02, Michael She wrote:
Hi all,
What does a 10,2 decimal definition mean.
Is it 10 Digits in total with 2 decimal places OR 10 integer digits with
2 decimal places?
The former.
For a 10,2 decimal column, should this be
MySQL Manager.
http://www.mysqlmanager.com
It seems to be the most professional of all programs I've tried.
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/
-
Before post
Hi all,
What does a 10,2 decimal definition mean.
Is it 10 Digits in total with 2 decimal places OR 10 integer digits with 2
decimal places?
For a 10,2 decimal column, should this be a valid number: 1234567890.12?
Thanks.
MySQL, SQL
--
Michael She : [EMAIL PROTECTED]
Mobile : (519
At 01:22 PM 12/18/2002 -0500, Michael T. Babcock wrote:
Michael She wrote:
X-MDRcpt-To: [EMAIL PROTECTED]
X-Return-Path: [EMAIL PROTECTED]
X-MDaemon-Deliver-To: [EMAIL PROTECTED]
2. Some of the comments in the mySQL manual... people losing data doing
routine stuff like table optimizations, adding
"proven" yet in the corporate environment
2. Some of the comments in the mySQL manual... people losing data doing
routine stuff like table optimizations, adding keys, etc. If a database is
reliable, things like that shouldn't happen. Comments like those in the
MySQL manual scared me.
;
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/
-
Before posting, please check:
http://www.
dreamweaver i get an unknown error, or unexpected. what do i need to do to
us dreamweaver on my development machine to access an mysql db on my server?
i have the pages hosted on my server but when i develop i use my dev
machine,
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW
faster (dual P3 1GHz).
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
_
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
subscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/
-
Before posting, please check:
http://www.my
Actually, no that isn't how I was doing it - I was concatenating multiple
inserts together like you do on SQL server. (ie Insert... Insert... Insert...)
Thanks for the Insert Sytax! I'll give this a go!
At 08:14 AM 12/11/2002 -0500, Anderson, Alan R wrote:
> From: Michael She [
rk. So are you saying that the Windows ODBC MySQL driver
doesn't support multiple statements?
Thanks.
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/
-
Before posting,
package that computer novices can use to build simple
web pages. Even if they know nothing of HTML?
I'm using mysql and I figure there might be something out there all ready
built. This is for a small college that teachers can use to put on there
stuff.
--
Michael She : [EMAIL PROTECTED]
M
loop?
Do Until rst.EOF
dbConn.Execute("INSERT STATMENT");
Loop
JFernando
** sql **
-Original Message-----
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: December 10, 2002 13:55
To: Fernando Grijalba
Cc: MySQL Help
Subject: RE: ADO Bulk Inserts
Hi,
That is how I
ts I get a SQL error.
At 12:55 PM 12/10/2002 -0500, Fernando Grijalba wrote:
Have you try this:
dbConn.Execute("INSERT INTO tblname(fld1, fld2) VALUES(val1,
val2),(val1,val2),(val1,vla2);")
JFernando
** sql **
-----Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]]
Se
les and columns?
JFernando
** sql **
-Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: December 9, 2002 14:56
To: MySQL List
Subject: ADO Bulk Inserts
Hi All,
Does MySQL allow for Bulk Inserts via ADO?
I can get a single insert statement to be inserted, but if I tr
documented and still in beta.
Thanks
Chandra
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi,
SHOW DATABASES;
At 11:35 AM 12/9/2002 -0500, Will Standley wrote:
I have two sample MySQL db's running on a local Linux box w/Apache...
Once I enter "mysql" from the Linux command line...
Is there a way to ask MySQL to list the db's that are currently created?
--
M
e the connection to the server.
I assume the server is running, because I can start and stop it through the
services interface.
However, whatever info I put into the Client - it will always give me an
error 145 (User can't connect).
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 58
doing the inserts through a ADODB.Connection.
Thanks.
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/
-
Before posting, please check:
http://www.mysql.com/manual.php (
still) _OR_ the MySQL*.rpm files on the mysql.com
site are not statically linked as they say they are.
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/
-
B
configure Windows MSSQL and UNIX MYSQL both
sides to implement replication?
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/
-
Before posting, please check:
http
database
equals todays date 09/12/2002
Dim TodaysDate
TodaysDate= cDate(Date)
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/
-
Before posting, please check
MySQL-Front isn't being developed anymore right?
Anyhow, the last version I used was very very buggy.
At 06:37 AM 12/8/2002 -0400, Chris Mason wrote:
I've found mysql-front to be far superior, in fact, I can't complain
about it at all.
-Original Message-
From: Mich
red Intelligent Converters at www.convert-in.com
Both look good.
The first is free and does more than convert Access to MySQL.
The second converts more stuff... like Excel to MySQL.
All comments encouraged.
--
Michael She : [EMAIL PROTECTED]
Mobile
ed Procedure
> - View
> - Trigger
I can't wait for these features too! But since some of the features are
slated for v5.0 - v6.0, I guess we won't be seeing them for a couple of years.
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepa
p
18MB of RAM.
Is there a way to minimize RAM usage? Maybe flush the RAM cache X minutes?
Thanks.
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/
-
Before posting, pl
rary table,
your RestTimes is a nice way to do it, but it multiplies the number of rows
of the table.
So you say it's better to have more rows than have less row, when doing
simple select query?
I'll do it your way then, except if somebody has a better idea ?
--
Michael She : [EMA
sts.mysql.com/php/unsubscribe.php
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:
Is it better to create a X AND Y index, or two
separate indicies?
Thanks!
sql, query, mysql, stuff to avoid the spam filter...
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryi
46 matches
Mail list logo
