- Original Message -
> From: "Alexander Mordach"
> Subject: Recordset item becomes malformed / truncated
>
> I’m working through a weird issue that revolves around LONGTEXT
> fields in our DB. For some strange reason whenever we add any type of server
> si
Hello,
I’m working through a weird issue that revolves around LONGTEXT fields in
our DB. For some strange reason whenever we add any type of server side
checking (Classic ASP) to an item in the recordset it loses its value and
becomes empty.
For example:
Assumption: “description” has a
Hi,
I'm sure this must've been done before, so if someone can point me at a
discussion or assist me in some other way I'd appreciate it.
If I'm browsing a paged list of invoices say in numerical order and I
then want to reposition the list on a certain client, I can do a second
query to the
At 3:00 PM +1100 1/22/07, Daniel Kasak wrote:
Hi all.
I'd like to be able to define a stored procedure that returns a
recordset ( I've done this bit ), and then select from this in
another query, eg:
CREATE [EMAIL PROTECTED] PROCEDURE `sp_MyClients`( IN ACCMAN INT )
BEGIN
sel
Hi all.
I'd like to be able to define a stored procedure that returns a
recordset ( I've done this bit ), and then select from this in another
query, eg:
CREATE [EMAIL PROTECTED] PROCEDURE `sp_MyClients`( IN ACCMAN INT )
BEGIN
select * from mirror_Clients where AccMan = ACCMAN;
EN
z
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: João Cândido de Souza Neto [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 14, 2006 12:00 PM
> To: mysql@lists.mysql.com
> Subject: Re
age-
> From: Vittorio Zuccalà [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 14, 2006 11:44 AM
> To: mysql@lists.mysql.com
> Subject: Max date in recordset
>
> Hello,
> i've a table with a lot of field and in particular:
> "InsertDate","Box","
If you're looking for the records from the last full day contained in
the data, not the past 24 hours according to the clock, then this
ought to work:
select * from table
where InsertDate >= date_sub( (select max(InsertDate from table),interval 1 day)
order by InserDate desc
Dan
On 11/14/06, V
select * from table where InsertDate = date_sub(now,interval 1 day) limit 3;
Not tested, but i think it will work fine.
""Vittorio Zuccalà "" <[EMAIL PROTECTED]> escreveu na
mensagem news:[EMAIL PROTECTED]
> Hello,
> i've a table with a lot of field and in particular:
> "InsertDate","Box","Prt"
Hello,
i've a table with a lot of field and in particular: "InsertDate","Box","Prt"
Example:
InsertDate, Box, PRT
2006-11-01, BXT, 34
2006-11-01, TTS, 33
2006-11-01, RRT, 55
2006-11-02, BXT, 22
2006-11-02, TTS, 99
2006-11-02, SAR, 75
I'd like to find all record inserted in the last day...
In thi
ri kritzer [mailto:[EMAIL PROTECTED]
Sent: Fri 5/12/2006 10:01 AM
To: Eland, Travis M.
Cc: mysql@lists.mysql.com
Subject: Re: ORDER BY making recordset non-updatable
That's a problem with SQL Server -- google search on your error and
you'll see that that's associated with SQL server, n
ject: Re: ORDER BY making recordset non-updatable
That's a problem with SQL Server -- google search on your error and
you'll see that that's associated with SQL server, not MySQL.
-Sheeri
On 5/11/06, Eland, Travis M. <[EMAIL PROTECTED]> wrote:
> Thanks for the response! Unfo
ct * from vwMyView" yields an updatable recordset.
Adding "Order by Name" to the end does not allow an update.
I should mention that the error associated with the lack of update is:
"Insufficient Key Column Information for Updating or Refreshing"
I have since futhered m
Thanks for the response! Unfortunately, it is that simple.
A basic "Select * from vwMyView" yields an updatable recordset.
Adding "Order by Name" to the end does not allow an update.
I should mention that the error associated with the lack of update is:
"Insufficie
o
update the data that I would expect to update (there are a few joins in the
view so there are a couple fields that I understand that I cannot update).
My problem is, if I add an ORDER BY statement at the end of this command, the
recordset still returns data, but it becomes non-updatable.
I w
would expect, and I am able to
update the data that I would expect to update (there are a few joins in the
view so there are a couple fields that I understand that I cannot update).
My problem is, if I add an ORDER BY statement at the end of this command, the
recordset still returns data, but
On Thu, 6 Jan 2005, sam wun wrote:
> Steve Buehler wrote:
>
> > At 08:11 PM 1/5/2005, you wrote:
> >
> >> Hi list,
> >>
> >> How can I traverse the recordset moret than once?
> >>
> >> For example, the recordset $sth is retu
5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: sam wun [mailto:[EMAIL PROTECTED]
Sent: Thursday, 6 January 2005 1:53 PM
Cc: mysql
Subject: Re: traverse the recordset more than once
Steve Buehler wrote:
> At 08:11 PM 1/5/2
Steve Buehler wrote:
At 08:11 PM 1/5/2005, you wrote:
Hi list,
How can I traverse the recordset moret than once?
For example, the recordset $sth is returned from executing the sql
statement.
The following statement is writen with the "for" loop for retrieving
each record from the
Steve Buehler wrote:
At 08:11 PM 1/5/2005, you wrote:
Hi list,
How can I traverse the recordset moret than once?
For example, the recordset $sth is returned from executing the sql
statement.
The following statement is writen with the "for" loop for retrieving
each record from the
At 08:11 PM 1/5/2005, you wrote:
Hi list,
How can I traverse the recordset moret than once?
For example, the recordset $sth is returned from executing the sql statement.
The following statement is writen with the "for" loop for retrieving each
record from the recordset.
$a
At 08:11 PM 1/5/2005, you wrote:
Hi list,
How can I traverse the recordset moret than once?
For example, the recordset $sth is returned from executing the sql statement.
The following statement is writen with the "for" loop for retrieving each
record from the recordset.
$a
Hi list,
How can I traverse the recordset moret than once?
For example, the recordset $sth is returned from executing the sql
statement.
The following statement is writen with the "for" loop for retrieving
each record from the recordset.
$aref = $sth->fetchrow_arrayref
However
SELECT table.some_column, table.another_column, ...
FROM table
WHERE some_column = 'some_value'
see the manual:
http://dev.mysql.com/doc/mysql/en/SELECT.html
On Sat, 24 Jul 2004 13:52:53 -0500, Robb Kerr
<[EMAIL PROTECTED]> wrote:
> I have a recordset that retrieves the full
I have a recordset that retrieves the full content of the table - all
fields, all records. Depending upon the content of different fields in
different tables, I need to display certain fields of certain records
within the full recordset. What's the syntax for selecting a particular
recor
Hi, I need desperatly some help.
I have two mashines and in ONE of them all Field Type that are "text" is
handled as Objects instead of String in my Windows 2000 server with IIS5
(ASP application) and mySQL.
I use mySQL ODBC 3.51 and mySQL server 3.23.55-nt
If I use "Response.Write(Vartype(rsSh
ECTED]
Sent: Thursday, March 13, 2003 5:20 AM
To: [EMAIL PROTECTED]
Subject: Recordset paging with php on mySql database ... works on first
page but ...
I had asked the group previously about limiting the results shown on my
website to a certain number and then navigating to the next group etc.
I had asked the group previously about limiting the results shown on my
website to a certain number and then navigating to the next group etc...
I found a great article by Joe O'Donnell called "Building A Dynamic MySql
Paging Class with PHP" ... I created his example and it worked fine.
Then I st
Name = "C:\\Path\file.xml"
rst.Open strFileName
That works for me
HTH
JFernando
** sql **
-Original Message-
From: Karl Stubsjoen [mailto:[EMAIL PROTECTED]]
Sent: December 15, 2002 00:46
To: [EMAIL PROTECTED]
Subject: ADODB XML Update Recordset
Has anyone any luck performin
Has anyone any luck performing batch update with a persisted ADO XML
recordset?
I'm trying to save data from one MySQL server and then upload/insert to
another. I'm trying to get these persisted XML recordsets to work, but
having no luck.
Any id
quot; Don't cache Results(only for forward-only cursor) ") and I solved the "
opening " problem... but it created 2 new problems:
1. the " closing " time is about 20 seconds (the same time opening the recordset
with that check unchecked)
2. I wasn't able to edi
At 19/10/2002 22:08, Patrick Sherrill wrote:
> It sounds like it may be time to look at threads. Set up a thread and open
> your recordset there or look at the C or C++ API for MySQL.
It's not a thread problem.
Thanks,
Massimo.
At 19/10/2002 17:17, Ed Carp wrote:
> It's not a MySQL problem, but a problem how you're opening the recordset.
> In VB, you would set the DBSQLPassThru flag - I don't know what the
> equivalent is in Windows C. The problem is that the client is downloading
> the enti
It sounds like it may be time to look at threads. Set up a thread and open
your recordset there or look at the C or C++ API for MySQL.
Pat...
[EMAIL PROTECTED]
CocoNet Corporation
SW Florida's 1st ISP
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]&g
Hi !!!
> Hi all
>
> I'm having a performance problem opening a recordset using a
> CRecordset class (Visual C++). If the table is empty (or
> contains few records) it takes a very little time to open,
> but if the table contains many records (about 48000 in my
> tes
> Does anybody know how I can solve this problem?
> How can I improve the " opening " performance?
> Does MySQL cache something for each records?
It's not a MySQL problem, but a problem how you're opening the recordset.
In VB, you would set the DBSQLPassThru
ing a recordset
Hi all
I'm having a performance problem opening a recordset using a CRecordset
class
(Visual C++).
If the table is empty (or contains few records) it takes a very little time
to
open, but if the table contains many records (about 48000 in my tests) it
takes
too much time
Hi all
I'm having a performance problem opening a recordset using a CRecordset class
(Visual C++).
If the table is empty (or contains few records) it takes a very little time to
open, but if the table contains many records (about 48000 in my tests) it takes
too much time (about 20 second
t; Emery
> - Original Message -
> From: "CP" <[EMAIL PROTECTED]>
> To: "NZEYIMANA Emery Fabrice" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Friday, September 27, 2002 10:47 AM
> Subject: Re: SHAPE command for Hierarchical Re
t: Friday, September 27, 2002 10:47 AM
Subject: Re: SHAPE command for Hierarchical Recordset
> I would suggest you use MS Access report with MyTool-DLL For VB and MySQL.
>
> - Original Message -
> From: "NZEYIMANA Emery Fabrice" <[EMAIL PROTECTED]>
> To: <[EMAIL
I would suggest you use MS Access report with MyTool-DLL For VB and MySQL.
- Original Message -
From: "NZEYIMANA Emery Fabrice" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 27, 2002 4:40 PM
Subject: SHAPE command for Hierarchical Recordse
I have created a MySQL database that will help me manage my Invoicing system
but I have been stack when I tried to print a report using a VB application.
I have read from Help that I will need to use a hierarchical recordset to
achieve what I want to.
You know an Invoice has some headers like
Have you tried to run the query in MySQL's console?
- Carsten
> -Oprindelig meddelelse-
> Fra: Rob Galvin [mailto:[EMAIL PROTECTED]]
> Sendt: 30. maj 2002 20:29
> Til: [EMAIL PROTECTED]
> Emne: ADO recordset is not returning rows in ASP page
>
>
> I have a
I have an active server page using an ADO recordset. When the SQL command is
a join of two tables with a count/group by there are no records being
returned (RS.EOF is true).
code snippet:
dbConn = "DSN=dbTestCases"
sqlVar = "Select " & _
"TestCases.Tes
Does anyone know of any weird issues with getting the value of an
AutoIncrement Primary Index field into a recordset? I do a sql call
from an ASP page that loads the Index and one other field into a
recordset. The other field contains the expected data, but the Index
field in the recordset
Hi,
I am connecting MySQL in Linux server through Visual
Basic in windows.
When i used the recordset to select a record,
the RecordCount method returns -1 even there is record
in the table.
following is the connection string i used
"Provider=MSDASQL.1;Persist Security Info=False;Data
S
, either MS or ChiliAsp! I get an empty recordset.
I do not believe the ASP is at fault as the query works perfectly when I connect to an
MS
Access database.
MySql version is 3.23.38
If anyone has any ideas why this is happening, or how I can work around it then please
could
you let me know
loop till EOF
adodataconnection ...
...
Set recordset = adodataconnection.Execute ("select * from t_table")
recordset.MoveFirst
Do Until recordset.EOF
...
recordset.MoveNext
Loop
recordset.MoveFirst' <- sequence error
Hi !!!
> -Original Message-
> From: Ing. Gustavo Edelstein [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 25, 2001 1:24 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Insert records in a VB5 recordset
>
>
>
> Dear members,
>
> I
Dear members,
I'm new to MySQL and I'm using MyODBC. I can connect to my MySQL localhost
from a VB5 appusing MyODBC. I can open a recordset (using RDO) and when I
try to add a new record I got the following error msg:
Run-time error 40069
Client Cursor: 40 - Assigned data excee
Sorry if this e-mail is rather long but I want to give all code I am using
as to make sure that everyone has all the information they need.
Machine info:
MySQL for Win 2000
IIS5
The Table:
CREATE TABLE Players (
pid INT AUTO_INCREMENT NOT NULL,
RealFullName CHAR(70) NOT NULL,
RealAge INT NOT NU
Hi There!
I have some trouble with a webaplication.
I used to run it with an Access dbase but have changed to a nice MySQL dbase and then
i got problems with the commands Addnew,Update,MoveFirst I use the samt locks and
cursors as I did earlyer.
Any good solution? Are there any parameters to s
cc
717.464.2970
-Original Message-
From: David S. Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 1:06 PM
To: [EMAIL PROTECTED]
Subject: problem updating recordset with MyODBC
When I try and update a recordset I get the following problem-
Microsoft OLE DB Provider for ODBC Drivers
When I try and update a recordset I get the following problem-
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Query based update failed. The row to update could not be found.
/Part1_Section1_Process.asp, line 82
Line 82 happens to be when I call rs.Update()
The problem o
gards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
- Original Message -
From: "Schrottemail" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 14, 2001 10:20 AM
Su
HELP!
I want to get the result of "show table status" into a ADO2.6 Recordset.
But the result of my query is EMPTY. But only in VB6. When I use the
"admndemo.exe" program it works.
Note:
"show status" works perfektly, only "show table status" and "s
guel
>I've scanned past e-mails and haven't found this in the archives. This is
>probably something simple that I'm overlooking.
>
>If I'm connecting to a table in MySQL from MS Access 97 and getting the
>message "This Recordset is not updateable" when
I've scanned past e-mails and haven't found this in the archives. This is
probably something simple that I'm overlooking.
If I'm connecting to a table in MySQL from MS Access 97 and getting the
message "This Recordset is not updateable" whenever I try and change
an
58 matches
Mail list logo
