11,093 Topics
 | |
| | can any body helpme on this point! i have the merge module MSDE n i have to deploy website to another PC i dont want that i install mysql there i want to attach just a fileor dll of database to the project set up . so i will not …  |
| | Hi , I have got a dump sql file from the remote db server and the concern is that i am new to the design which involves the triggers and all. When i tried to set up a environment for a application to play around locally , the import shows … |
| | hello i have my data stored in different Ms Excell sheets. now I am planning to make a database of the data i have. but i m confused whether to use Postgresql or mySQL for the same. i had plans to import data directly to Ms Access but there is … |
| | Hey guys, im in deep need of help for mysql. Ive been given a few questions most of them answered although theres 3 which are really bringing me down. I was wondering if u could get some help :D Given this schema borrow([U]transactionID[/U], personID*, borrowdate, duedate, returndate) author([U]authorID[/U], firstname, middlename, … |
| | I'm building a large scale application and was wondering the difference between static counts vs dynamic counts. Right now, I'm using dynamic counts. For an example: [code] SELECT *, (SELECT COUNT(1) FROM CarImages WHERE CarImages.carid = Cars.id) as ImageCount, (SELECT COUNT(1) FROM CarBuyers WHERE CarBuyers.carid = Cars.id) as BuyerCount, (SELECT … |
| | Hi, I am currently trying to write some sql that includes a where clause to limit responses but will leave blanks where there is no match. I will include the code so its easier to understand: SELECT DISTINCT teacher.teachername, student.studentname, results.grade FROM teacher INNER JOIN student ON teacher.teachername = student.teachername … |
| | Hey guys. I know this is more of an sql problem but I didnt know where else to put it :S I have an application which stores a UNC path in a mysql database table. However it doest store it correctly for example: I want to store the UNC Path: … |
| | i would like to know how i can save data from the list view to mysql. i have two coluns on the list view and i would like to save all the items that are in the list view. |
| | I have been looking at this code for some time and just can not figure anything wron with it. My Error Message is: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/gwthorn/htpsinc-web.com/York_County/login.php on line 13 I commeted 13 [CODE=php] <?php session_start(); //The fields are censored but …  |
| | hi guys.. i really tried many things to solve this problem.. but i really cant figure this out.. i have 2 tables actually its 3 tables but the other is just for the user's account so here it is: [B] employee table [/B] ins_ID -> pk emp_ID* -> unique key … |
| | This is my current database structure [php] create table tournament ( tid int(5) not null auto_increment, period varchar(20) not null, Primary key (tid)); create table game ( gid int(6) not null auto_increment, tid int(5) not null references tournament(tid), Primary key(gid)); create table results ( gid int(6) not null references game(gid), … |
| | How would you execute MySql commands found in a text file? It's really beginning to bug me!  |
| | I am new to PHP. I am trying to connect mysql with PHP with mysql_connect but i m getting "A link to the server could not be established" I have used ODBC 3.51 driver for odbc and made connections with odbc with odbc_connect but i don't know how to connect … |
 | Hi there, I'm trying to screen some programmers I'm looking to potentially hire & I have a list of questions a previous programming consultant drew up, but I don't know what to do with them b/c he did the screening b4. Can someone please help me determine if I place … |
| | Any one doing sever programming with MySQL please let me know , all problems that can occur with connectivity of MySQL with SJSAS 9. There is a connectivty setup in the Admin Console. It is a bit confusing with duplicate Capital and small letter entries. Can we use the XADataSource … |
| | Hi , I've been working on comparison query with PHP and MySql 5.0 yet not getting anywhere with it. I'm trying to perform a search ( query ) I have several tables within the same database that contain same fields yet hold different data eg Table 1 id |Product | … |
| | Hello, I have two databases on my website lebphoto.com with the same tables. One with a 1665 members and the other with 33 members, I want to merge them together. is there a way other than typing each records by myself or ask the members to register again? Thank you |
| | I hope someone can helkp me. This is driving me nuts. I have the following code that produces this error " [B]Exception Details: [/B]System.Data.SqlClient.SqlException: Login failed for user 'selfmadeBrowser'." The entire code is as follows (please note, this script came DIRECTLY off of [URL]http://www.expertrating.com/courseware/DotNetCourse/DotNet-ASP.Net-4-3.asp[/URL], I also am able to cnnect …  |
| | I know this is pretty dumb question but I just wanted to ask because I am not sure if I can figure it out by myself. :( So here is the deal. I have a mysql database called "appinfo" there there is a table called "appdis" Now in that table …  |
| | Hello all, I have been using mysql_fetch_array to read data from a query to a php array so i can then use it on my webpage. Everything was going fine until now... I cant see the problem with my code, but it keeps calling the or die() error handler when … |
| | Hello all, Is there any algorithm to convert a python tuple to [URL="http://www.daniweb.com/techtalkforums/thread74502.html#"]MySql query[/URL]. Ex: [B] ('*','name','sliver')[/B] should convert to [B] select [Pri_Key] from [All Tables] where 'name' = 'sliver';[/B] I have been able to do so ... but my [URL="http://www.daniweb.com/techtalkforums/thread74502.html#"]algorithm[/URL] looks very ugly and have to process everything bit … |
| | Hi, How safe is to allow users to submit the entries with single or doube quotations to the database? and wondering is there any free site or service to check vunerabilities of the site? Hope to see it in daniweb. Thanks!  |
| | Hey, first poster here: I'm not actually running on MySQL (I'm using MS), but my question is more of a design issue. The model I've been using is perfect for maintaining relationships between data logging devices I have in the field, and so-so in keeping an aggregate of that data … |
| | Please help - Why can I get this sql to work? SELECT Count(dsd.price) Total , dsd.reporting_date , dsd.reporting_state_type , dsd.requisition_id Order_id , round((sum(decode(dsd.reporting_state_type,'SHIPMENT',dsd.price, 0)) - sum(decode(dsd.reporting_state_type,'RETURN_RECEIPT',dsd.price, 0))) Net_Orders from dw_sales_data dsd, dw_programs dp where dsd.program_id = dp.program_id and dsd.program_id = '4387300' group by dsd.reporting_date, Order_id, dsd.reporting_state_type, Net_Orders_Com, Net_Orders_Ret, Net_Orders; |
| | :sad: I am trying to connect to a mysql database. ideally, i'd like it dumped into a grid view so i can edit it... no matter how i try it, i get this error- [B]Compiler Error Message: [/B]BC30002: Type 'ODBCConnection' is not defined. here is the code for this page: …  |
| | How can I maximise the command line window of this progamme as click and drag does not work? |
| | [COLOR=#000000]Hi ! I have a problem in connecting JSP pages with My SQL database using JDBC connector. I m using:[/COLOR] [COLOR=#000000] [/COLOR] [LIST] [*][COLOR=#000000]For TOMCAT -- apache-tomcat-5.5.23[/COLOR] [*][COLOR=#000000]For JRE -- Java EE 5 SDK[/COLOR] [*][COLOR=#000000]For database -- MySQL 5.0.37[/COLOR] [*][COLOR=#000000]For JDBC -- mysql-connector-java-3.0.17[/COLOR][/LIST][COLOR=#000000] [/COLOR] [COLOR=#000000]JSP pages other than database working … |
| | I want to make a query in C++ using the MySQL++ API. Here is my problem, in PHP for example I make something like this: $query = "SELECT * FROM table1 WHERE id = " . $value; In C++ I can't do that. I need a way to make $value …  |
| | Well, whenever I try to run a user verify script, that asks SQL if a username is not taken, I always get this response... [quote][B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]dir/userver.inc[/B] on line [B]11[/B] count unavailable[/quote] this is the code in general: [php]<?php //User …  |
| | Hi, This is a simplified problem for a mock book store I am trying to build. I have been stuck on this all morning. Any help would be appreciated. Thanks. [U] SET 1[/U] | 1 | a | | 2 | b | | 3 | c | | 1 … |
| | Having a diificult time with date range in a pawn database: Any suggestions  |
| | Hi all Can someone tell me how to connect to msql database using c# 2003. can you please show me the steps to take. i have tried many times without success. Are they compatile? Thanks sibotho |
| | Hi there, I am relatively new to MYSQL and i have to design a database for stock for a dvd firm, this database has to link up to a website, the website is a DVD firm so the only things that needs to recorded in the database is how much … |
| | is there any way through which we can generate reports in mysql. not using any s/w but coding. if yes plz tell me Thanks |
| | Hello I´m trying to make a function that give-me data from a data base mysql at time there is no problem but i would like to now how i can make that funcion to be called from x hover x seconds, the ideia is just to se if there is …  |
| | hello, i need help!!!!! i would like to know how i can make a backup and restore of my db mysql from one form??? |
| | hi all i m making a project using jsp as my front end and mysql as my back end. i had to change backend from oracle to mysql bcoz of clients request. now there is 1 problem i m facing. there a password change option. person enters its old password … |
| | hi, it is giving me headache to write data from a php file to mysql( i can read from the table but cant write) here is my connect.php which connects to mysql: [CODE]<?php $mysql_host = "localhost"; $mysql_user = "sam"; $mysql_pass = "123456"; $mysql_data = "website"; $mysql_table = "shoutbox"; mysql_connect($mysql_host,$mysql_user,$mysql_pass) or … |
| | Does anyone know the name of the MySQL library package? I'm working with a server that recently had an upgrade from PHP 4 to PHP 5, and apparently PHP no longer provides built-in library files for MySQL. The system in question should have the libraries from PHP4 on it somewhere, … |
| | I hav calculated a value(years).Now i want 2 merge it with an attribute of a table.So i want 2 merge ml_y and 2.then i want to find the value of ml_y2 frm a table....plzzzzzzzz help me .can i do somthing like this in MY SQL??? |
| | [B]When i try to access this page: it shows this: Warning: mysql_query(): 2 is not a valid MySQL-Link resource in /user/langlab/wwwhome/signup/signup_adm.html on line 28 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /user/langlab/wwwhome/signup/signup_adm.html on line 29 Warning: mysql_query(): 2 is not a valid MySQL-Link resource in … |
| | i m exporting my table from one system to another. when i do shell# mysql databasename<file.txt i get the error given above. the table i create is -> CREATE TABLE entrytab ( uname varchar(10) default NULL, enterDate date default NULL, status varchar(10) default NULL, productName varchar(15) default NULL, featureName varchar(20) … |
| | hi every1 i m using jbuilder9 to develop my website and mysql as its back end when i use mysql with simple java program it runs as i store the jconnector in jdk1.3/lib/ext. but when i stor the jconnector in jbuilder/jdk1.3/lib/ext it does not work. can any 1 plz tell … |
| | hi every1 i hv created my database in mysql now i have to run the s/w on my clients system. can any 1 plz tell me the steps to export the mysql database and then to import it on my clients computer. thanks in adv |
| | Is there a free Host in the Net ... which host ASP and MySQL do anyone of u know..please post if u know..... |
| | Can someone start a tutorial about MySQL++ combined with Win32? I would like to learn about that |
| | Hi I am very new to MySql. I want to use Navicat along with MySql server to develop and maintain very simle database in future. Up to this point it is OK. I want to develop and maintain a small customer database. My question is do I need a GUI … |
| | Hi, Can someone please give me examples or teach me how to design and implement in MySQL a normalised database for any case study they have in mind.. Please help me out as it would really help understand a lot better or if you can give me a link to … |
| | Hi, I am trying to get my head around the whole database theme by learning MySQL on my own with the help of a couple of easy to use books and some online forums including this one. Is this is the right choice in terms of learning the database related … |
| | Hi, I am trying to understand MySQL as i am new to this and i have a few queries I am having problems with and I was wondering if anyone can help me with it.. How would you solve this problem using the Select, from, where etc commands. For example … |
The End.