11,093 Topics
 | |
| | 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 … |
| | Is there a site that will tell you how to make a traffic exchange using PHP and MySQL or is this something that is better to get a script for? :?: I am trying to learn PHP the best I can and it is difficult to learn how to make … |
| | 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 … |
| | Am new to SQL and PHP. Only been using them for about 3 weeks to create an e-commerce site for some friends. I have been trying to set up a link to paypal's shopping basket feature from my listing page. I'm trying to get the link to appear next to … |
 | 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.*; … |
| | Hello This Is My Tutorial Over "SQL INJECTION" , Hope It Would Help Out Many Out Here. Basically SQL INJECTION Is A Attack Over Weak Programming And Can Affect Major Over The Databases. No Lets Jump Out Here: Consider a Form As Shown below, [url]http://www25.brinkster.com/vinothbabu/login.asp[/url] The Form Accepts a Username … |
| | 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. |
| | Im having these problems, it used to work in my website for almost a year then suddenly this error occured.. [B]Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/alexsl/public_html/admin/system/[B]functions.php [/B]on line 291[/B] here's [B]functions.php[/B]: [code=php] <?php // Somery, a weblogging script by Robin de Graaf, copyright …  |
| | Hi, Was wondering if anyone could help me with this little problem I'm having. I'd like to have a comma separator after every 3 digits. E.g "3,000,000". How would i go about this? Thanks in advance  |
| | |
| | Please tell me the method of installing jconnector for my sql server  |
| | Hi everyone. I`m looking to solve an issue. My problem is : i have more tables, but in my example will be only 3 with 2 columns: users (id,nick) comm (id,userID,text) rev (id,userID,text) So , i need to count the comm and the rev that users make, multiiply by a … |
| | How to fastening inserting data on mysql??? I have 5000 record in excels. And I want to insert all record to mysql.. and it take time abaout 6 six minutes.. How to fastening become under 20 second to insert all 5000 records?? Peace DODOl |
| | hi all, I am a developer intending to do Mysql 5.0 Developer Certification. How this certification is valued in the IT industry? Is it worth doing MySql certification? Please advise. And if anything you want to say about Mysql 5.0 Developer Certification. Thanks |
| | i am writing code and also the error i am facing in database connectivity in jsp to mysql .plz help me .thanx code import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.sql.Connection; import java.sql.*; import java.io.*; public class ConnBean { Connection conn; Statement st ; public ConnBean() { String sqlDriver= "com.mysql.jdbc.Driver"; … |
| | Hi out there!! I have a problem in creating relationships in MYSQL. could some help me out there? Am a beginner in system development and I would like to learn more. YOuare great |
| | I'm developing a small, web-based poetry sharing website. I'm a beginner in PHP and MySQL. I want users to have a personalized page where they can work on their work in progress, once they feel they can publish it for the other users to view. I've already created a login … |
| | Hi, I'm newbie here. I just noticed that HR control panel have no feature to check and repair MySQL database if the database got corrupted. I knew CPanel have this feature and I guess the HR control panel look similiar like CPanel (CMIIW), but no feature for Check and Repair … |
| | I was reading through my java book which is called Introduction To Java Programming Sixth Edition by Y.Daniel Liang and I was reading about databases. I just wondered if java is used in webdesign for the purpose of creating databases and if that was instead of MySql and what the … |
| | Greetings. My first post. I'm running a fairly popular wordpress blog (about a million page views a month). I have a plugin called "recent comments" which lists the last 20 or so comments in the sidebar of the site. However, the queries it makes are very disk and CPU intensive. … |
| | PHP version 5.1.6 MySQL version 5.0.27-standard-log Table is super simple, 1 primary key, uid, unixtime(timestamp),blog, pro, bull, pix [code] if($uid > 0 && $id != $uid){ include('connection.php'); mysql_query("INSERT INTO history SET uid='$uid', pro='$id'"); } Thats all. Does anyone know why this would create two identical records every time? [/code] Anyone … |
| | [COLOR=Red]IP addresses instead of localhost or 127.0.0.1[/COLOR] I want to buils a web server which will work fine not in localhost. It should work online as a web server from which i can host my own websites and visitor can visit these from other PCs. So, how can i proceed?? … |
| | hai,i have a table,consists of data which gets updated data time-time.i want to access the data based on date & time. |
| | I am new to PHP and I don't have a seperate server. I am running Dreamweaver CS3 with Developers toolkit and Xampp 2.1.10. My problem appears to be that I cannot get my head around whether I need to have a seperate server, or whether I can do everything locally. …  |
| | I have uploaded the site and get this error message on the home page: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/d/t/e/dtedder/html/index.php on line 55 line 55 of index reads like this: $totalRows_rsArticles = mysql_num_rows($all_rsArticles); Any suggestions? |
The End.