10,940 Topics
 | |
| | Hi All I am trying to connect mysql and VS 2003 but i am unable to do the connection, which makes me wonder if the are compatible. Can someone tell and also give me the code for connection. Thanks in advance. |
| | Any idea? I get this error: org.apache.jasper.JasperException: An exception occurred processing JSP page /test2.jsp at line 7 4: <title>DB Test</title> 5: </head><body> 6: <% DBConnect d = new DBConnect(); 7: ResultSet rs = d.getResult("SELECT name FROM items"); 8: 9: while (rs.next()) { 10: String name = rs.getString("name"); Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:435) … |
| | [code] public static Connection getConnection(){ if(connection==null){ try{ Class.forName("org.gjt.mm.mysql.Driver"); connection=DriverManager.getConnection("jdbc:mysql://localhost:8084","root","ceyesuma"); }catch(Exception exc){ connection=null;} } return connection; } [/code] Here is the bean to get connected. Should this work? [code] package db; import java.sql.*; import java.sql.DriverManager; import java.sql.Connection; /** * * @author James */ public class DBConnection { static String dbdriver; static … |
| | I made more progress ong CreditCard program I am trying to insert a row into mysql from a creditcard account number. Could I get some feed back on why it as a problem with the url it looks like it wants to insert a record. [code] package creditcard; import db.DBConnection; … |
| | I would like to return a connection to a Bean to make statements to mysql database "ccdb" I'm really not sure of [code] public static Connection getConnection(){ if(connection==null){ try{ Class.forName("org.gjt.mm.mysql.Driver"); connection=DriverManager.getConnection("jdbc:mysql://localhost:8084","root","ceyesuma"); }catch(Exception exc){ connection=null;} } return connection; } [/code] Here is the bean to get connected. Should this work? [code] … |
 | i have this code: include('DB_connection.php'); $result = mysql_query('select * from login'); $count = mysql_num_fields($result); for ($i = 0; $i < $count; $i++){ $header .= mysql_field_name($result, $i)."\t"; } while($row = mysql_fetch_row($result)){ $line = ''; foreach($row as $value){ if(!isset($value) || $value == ""){ $value = "\t"; }else{ # important to escape any … |
| | What are the performance implications of storing some data across 2 databases instead of duplicating this data in both databases? ie. is example 1 significantly slower than example 2: Example 1: SELECT Users.User.*, Transactions.Sales.date FROM Users.User, Transactions.Sales WHERE Users.User.id=Transactions.Sales.userid; Example 2: SELECT Users.User.*, Users.Sales.date FROM Users.User, Users.Sales WHERE Users.User.id=Users.Sales.userid; Note … |
 | I have one doubt about WAR file........ Like i am creating a project with mysql databse and deploying it through WAR file My question is if i want to deploy it on some other machine then i am copying war file there in webapps folder.........but do you think it war … |
| | Hi All I am trying to create 2 tables Table 1 with cust_id , username and password (Cust_id is primary key here) Table 2 wth cust_info that will store info for that cust........now i want to use this Cust_id as foreign key here in table2 but i am not able … |
| | Hi, I have been searching around for a few days and cannot find exactly what I looking for. Was hoping someone could point me in the right direction. Looking to query MYSQL with keyword. For each of the records or rows its finds based on match. Would like to retrieve … |
| | I need a simple login script that has the ability to redirect a user. For example: - I want to be able to protect certain pages so that a user has to login to access them (in this case they wouldn't get redirected) - Then in another case I would … |
| | I have a Database which is dealing with a book library system. I have a table which has a has a field dealing with the ReturnDate of a book. I was wondering if it is possible to do a SELECT statement that would return the the fines due on an … |
 | I want to generate a code that will automatically take the poll-id..of which the user wishes to view the result of that poll. there's the code:using mysql & java & another thing i wish to use this on a jsp page: [code] package votepiepack; import java.sql.Connection; import java.sql.DriverManager; import java.sql.*; … |
| | I'm posting in the PHP forum cause that's what I'm using to connect to MySQL. If there's a better place to post this let me know... Anyway, I have data that consists of discrete lines of text which must be in a certain order. Like if you were taking a …  |
 | [B]I want to create a table, with a column which datatype will be LONG BLOB, what will be it's size????? e.g. [U][I]create table tab1(name varchar(20), pic longblob([COLOR="Red"]?????????[/COLOR]));[/I][/U] plz give me the currect code...........[/B]  |
| | Dear members, can any body plz help me out to insert image file in MySQL.......is it possible ???????? [B]If possible plz give me the code............[/B]  |
| | I have been looking into ways I to cut down on MySQL Querys in a page and I was wandering if you could up to update querys into one mysql_query function like this: [php]mysql_query("UPDATE table SET val1=val1+1, val2=val2+1 WHERE id = (int); UPDATE table SET val3=val3+1, val4=val4+1 WHERE id = … |
| | Hi all, I'm facing a big problem using MySQL...i've created a table using this code: [code=sql] create table table1(name char(20), age int(3)); [/code] Now this table can insert ineteger values in name field........which i don't want and the age field can take a value like e.g. 123456789...although it's length is … |
| | Hello, Please, i need to know the JDBC code (applying servlet) to use with mySql to generate account balances from my customer_table having three columns(i.e. DEBIT, CREDIT,BALANCE) in the following format: CR-------------------------DR----------------------BALANCE 30................................5..................................25 2..................................3..................................24 I can only use 'select sum....' code to get the sums of both DR and CR …  |
 | I am searching for a long time in my laptop (WinXp) from where starts the services like mysqld.exe and java.exe. They start at boot time and make 860 MB use of virtual memory. They seems to be connected (mysqld and java) because when I stop the mysqld only, my Virtul … |
| | Hey guys. Got a quick question. I am having a problem with a message board that I am creating. I have created the log in and registration page and the sessions needed to use the site nad it all works fine, but when the user posts a message I can't … |
| | Can anyone give me the step by step explanation for connecting asp.net with MYSQL  |
| | Anyone know where I can find a good MySql and C++ Tutorial? I want to us MySql w/ MFC C++ Thanx, Atrus |
| | Hello, I want to learn perl and I have installed Apache 2.0.53, Perl 5.8.8 and MySql 4.1 I have configured apache for perl and successfully running the "Hello World" program. I want to know, how to configure perl for mysql. Your help is appreciated. Thanx  |
| | |
| | Hi, I've tried several of the fixes for this that I've found on here, but I haven't been able to find a work around. Here is the code that I'm having the trouble with: [code] mysql_select_db($db_name,$db); $result = mysql_query("SELECT * FROM pages WHERE pagenumber LIKE $pagenumber ",$db) ; while ($myrow … |
| | Hi This is my first post here and I have just started using php so please be kind LOL I have tried to use the script below to do a search on the database but it keeps spitting out [B](Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource …  |
 | I have installed MySql 5.0 and also configured but after installation it shows " The Service couldn't be started" Plz help me out  |
| | Hello All, I have been trying to pass variable values as a parameter name in MySQL Stored Procedure Insert Statement when i directly pass the parameter name it works fine, but when i asign the paramter name from a variable value it is passing those values as a value not … |
| | i tried like a million things and im ready to murder someone, can someone walk me through it? thanks. |
The End.