10,940 Topics
 | |
| | 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 … |
| | [COLOR=midnightblue]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_yaf_Forum_yaf_Category". The conflict occurred in database "yafnet", table "dbo.yaf_Category", column 'CategoryID'. The statement has been terminated. How to solve this error...........[/COLOR] |
| | I have a db full of articles that have a category field. Is there anyway to select and display just the different categories? |
 | how can i retrive data from database (mysql)and make it a drop down menu on a html form using php .and also if an iteam is selected from a fist dropdown before the next well become active. |
The End.