10,932 Topics
![]() | |
Hi, I'm developing a VB6 application connecting to a MySQL database. I'm getting run-time error 3001: arguments are of the wrong type, are out of an acceptable range, or are in conflict of each other. I'm using the ODBC driver from MySQL. I would appreciate if anyone could spot where … | |
Hello guys, i been searching this for a month still cannot find anything. is there any way to copy mysql table to ms access? Best Regards | |
Hello to all, Being in a pretty much international company, I have come here to ask a few things about ETL tools and their different languages. We have offices in the US, in Europe (Italy, France) and in China. We think English is fine but our European team and Chinese … | |
Hey all - I did a bit of searching and read up on the "..not a valid MySQL result resource" error.. but I can't seem to fit any of the solutions to my code. Can I please get some help? Here is the error: Warning: mysql_num_rows(): supplied argument is not … | |
Hi , I have MYSQL version 4.1 to get size [code=sql]SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB", sum( data_free )/ 1024 / 1024 "Free Space in MB" FROM information_schema.TABLES GROUP BY table_schema ; [/code] But there is no … | |
pleaseeeeeeee hepl meeeeeeee!!!!!!!!! i have 2 tables : time1 (noo integer,days varchar,times varchar,Tindex integer,primary key (noo,Tindex)) timetable1_1(COn integer,coursename varchar,dayss varchar,timess varchar, primary key(COn)) i have created a new table temptime1 and tried to fill it with the rows in time1 which their days and times are not available in timetable1_1 … | |
I am new to programing and am impressed with the ease of python/wxpython. I have written useful wx programs to enter data into MySQL databases, but am stuck on making a useful wxpython MySQL query progam. I have had success writing query apps in python. I'm hoping to find a … | |
Hi everyone! Im actually doing my final year project which is an ecommerce application for a specific business. there is another student who is working on the MIS part of this business. we have to use the same database. I am using PHP and MySQL and he is using ASP.net … | |
I have a table with 15,00,000 rows which has a column PERMLINK which is used in 'where' clause of my select queries. To speed up query I have used it as INDEX. What size of index is optimum for names.? and I have a new idea but don't know how … | |
i already have a running code regarding this, however, when i embed the database, it cannot access the next records...help pls.. ![]() | |
Hello I want to update a table with ID from another table, where the companyname field within the tables match as below ABC LIMITED Would Match AST BIRCH CONT LIMITED I basically want to take the 1st letter of each word Can someone help me | |
I need to format PHP to use with one of my date field (DATETIME). I want to get current time and format it. I have checked some googled articles but I cannot get far. Please help me! | |
Hello, Thanks in advance to anyone who can answer this question. Can I record a users ip address without them logging into my site? I have a list of documents that I would like to make available and would like to get an idea of who may be viewing them. … | |
Hello, I'd like to create a basic html form where a user can submit their email address for a cooking class. There would only be room for 20 people so I'd like it to accept the first 20 user and display a "check back next month" to anyone past 20. … | |
Hello, I am working on a website using a MySQL database, certain pages contain tables from the database. Also there is an admin where someone can edit (replace) values in the table. Everything is working, but I have one problem. A row in the table is named 'Best Moment' which … | |
I got a problem when using mysql connector with wxWidgets my program crashes right when I start debugging, but it gives no compiler errors. Main.h [code]#ifndef __MAIN_H #define __MAIN_H #include <wx/frame.h> #include <wx/textctrl.h> #include <wx/button.h> // Mysql #include "mysql_connection.h" #include <cppconn/driver.h> #include <cppconn/exception.h> #include <cppconn/resultset.h> #include <cppconn/statement.h> class MainApp: public … | |
I have been searching the web for this but cant find it anywhere, i want to search my mysql database with php but i want it to find records if just one of the search term word are met. eg. Search term from form = "one two three" My database … ![]() | |
I want to transfer data from mysql database to an msexcel sheet... Is it possible with java. how? | |
Hi. I tried looking for this problem on Google, and found a lot, but nothing that actually seems to work. I basically have a search script that works fine when using one keyword, but when one uses more than that, it returns every single row per keyword. So a search … | |
Hi, I am trying to backup one of my Mysql database with a PHP script. [code] <?php $host="localhost"; $database="toy"; $username="root"; $password=""; $connection=mysql_connect($host, $username, $password); if(!$connection) { die("ERROR: Couldn't connect to the server."); } else { $dbSelect=mysql_select_db($database); if(!$dbSelect) { die("ERROR: Couldn't select the database."); } else { $mysqldumpPath="/usr/bin/mysqldump"; $backupFileName = "Desktop/toy-`date … | |
I'm not sure if this is possible but I'm kinda stuck in the middle. For my script I need to calculate the server load and the mysql cache usage both in percentage. Does anybody know of any scripts I can use for this. There are probably open source things that … | |
Not sure if I have the right forum...but I am wondering....my employer has advised me that I am going to need to start working with an accountant as I am the DBA. Is this becoming more and more common that DBA's have to work with financials as most databases are … | |
Hi i have table with following structure mysql> show create table proc\G; *************************** 1. row *********** Table: proc [code=sql]Create Table: CREATE TABLE `proc` ( `a` varchar(16) default NULL, `b` varchar(16) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1[/code] i want to insert values into table proc through procedure what should be the … | |
Hi, I have created a php file to upload images i want this to store the image name in a mysql database. I created this php code but when it comes to storing the file name in the database it stores each file name in a new row. Can anyone … | |
I have been working on this problem for a few weeks now and everything I have tried will not work. I am new to working with PHP and MySQL and have never use a forum, so you can say I am new to everything right now. When I try to … | |
How to encrypt and decrypt an existing column ? | |
Topic The topic of this question is: db_Connect does not connect. Hello and Thank you in advance for any assistance. [b] System info:netbeans project,database attached or provided at: [url]http://cid-b5cb457363230793.skydrive.live.com/self.aspx/.Public/school.zip[/url] [/b] [b] The purpose of this post is: Try to get a sql statement to work [/b] [b] The functionality of … | |
I had a code written long time ago which was working fine for small records but as the number of records begin to increase it completely failed. I am attaching the file with comments which will help you understand the problem. For fewer records you can see it working at … | |
hi i am new to this forum. i am able to add image file(a.jpg) to mysql databse. when i see the file in a databse . i could see the file.but when i try to retrive that file ia m getting error.can anybody help me thanks |
The End.