Search results for query: *

Thanks DonQuichote and Jpadie for your response. Data was being dropped, as suggested by Jpadie, so I used the following command before fetching the data: ini_set("odbc.defaultlrl","99999999"); Issue resolved. Thanks again.

I am unable to view pictures (jpeg) from a MSSQL Server 2005 database (BLOB field), no image is displayed on the web page (red X displayed). Also as a troubleshooting step, I displayed the content of the BLOB field and got some characters which I dont understand. Picture type: JPEG PHP...

Thnx Qatqat. I am using InnoDB tables. But the strange thing is that the lock now works correctly once i remove the TRIM command from my SELECT statement.

I am using VB6's SELECT..LOCK IN SHARE MODE command. However, the entire table is being locked when i try to select and lock just 1 record. I "solved" this problem by adding a primary key to 1 of the tables. Now the other table has a primary key and index but I am still having...

thnx i will try that.

After loading the records in MSHFlexGrid. I need to display all the fields of the record/row that the user double clicked (selected) in the MSHFlexGrid. I notice that the value of field that was doubleclicked will be assigned to MSHFlexGrid.Text. But I want the values of the other fields also...

I am using MyISAM Tables.

See the following website: http://www.mysql.com/doc/en/Windows_installation.html

Thank you all 'MYSQL -u username --LOCAL-INFILE=1' worked.

I am using VB6 to add records to a MySQL database. I would like to know how to check if a table or record is already locked. See the code below :-- sSQL = "Update ItCustmr Set...etc. etc." 'BEFORE LOCKING I WOULD LIKE TO CHECK IF THE TABLE 'ITCUSTMR' IS ALREADY LOCK...

Thank you all for your response. For info on MySql see: www.mysql.com

I am new to MySQL and VB6. This is my situation, I am creating a multi-user application with VB screens as the interface and MySQL as the database. My problem is VB reads the MySQL database using SQLs (Cursors), so individual users will not see new records that are added because each user is...

When I execute the follwing command: LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet; I am getting the following error: 'ERROR 1148: THE USED COMMAND IS NOT ALLOWED WITH THIS MySQL VERSION' I am using MySQL version 3.23.54-max-debug. I start MySQL with MYSQLD --LOCAL-INFILE=1 I...

I am new to MySQL and VB6. This is my situation, I am creating a multi-user application with VB screens as the interface and MySQL as the database. My problem is VB reads the MySQL database using SQLs (Cursors), so individual users will not see new records that are added because each user is...