10,942 Topics
 | |
| | 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 … |
| | [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] |
The End.