Hi, I am getting following error when I try to perform login validation using JSTL Custom Tags org.apache.jasper.JasperException: /checlLogin.jsp(12,38) Unterminated <sql:setDataSource tag Please find below software specifications I have - I have placed JSTL.jar and Standard.jar at CATALINE_HOME...\WEB-INF\lib - Working with s...
My create table command in mysql is CREATE TABLE `map` ( `id` int(4) AUTO_INCREMENT NOT NULL, `city` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB; CREATE UNIQUE INDEX `map_city_idx` ON `map` (`city`); Intial value, like: id(1),city('Banda Aceh') id(2),city('Medan') The next insert is city('Medan'), so...
Please I am very new to PDO, rather a novice at PHP as well. I am currently working on a project that involves connections to many databases: MySQL, MSSQL and Oracle. So I am using the class below, with PDO, for my connection. The class code is below. class db { private static $objInstance; /* * Class Constructor - Create a new data...
I have a question and I'm not sure about the best way to design it. Basically, there are users. Each user can have a message box, and each box in turn can have several messages. The problem is, is that there are some special message boxes, including "New," and "Trash." A user is required to have these two boxes. I had some ideas abo...
I have a table entity called position. I am storing the value using smallint(2) datatype, where I intend to store the value from 0 to 9 (max). I want to make sure the value is just a single integer and an integer should not be repeated at any cost. There should be a unique value assigned to each id of the position entity in the table ran...
I am suffering from abysmal INSERT times on my MacPro (quad-core 6G memory) running mysql 5.1.49 on snow leopard 10.6.4. I tried to figure out where the problem is and finally came to the conclusion that it must have to do with Mac OS X. Here is the test I ran. I have an old dell with a single pentium cpu and 256M memory and mysql 5.1.4...
Query: SELECT t1.id, t1.ads_city, t1.ads_title, t1.ads_description, t1.ads_type, t2.ads_activate, t2.postads_id, t2.ads_id FROM table_1 t1 JOIN nextpostads t2 ON t1.id = t2.postads_id WHERE MATCH(t1.ads_title,t1.ads_description) AGAINST ('LCD projector ,' IN BOOLEAN MODE) AND...
I have a table let say is it called "test". I use Ubuntu and MySQL 5.1.41-3ubuntu12.6 version. If I try to do "select * from test" it works but if try "select * from Test" or "select * from TEST" it does not work. Does any had this problem, or knows how to solve it? Thank you. ...
I am writing a small tool for managing the people registered to an association. I have a table USERS and a table CARDS. Each user can have more than one card (because cards expire). With one query I would like to extract ALL user information plus ALL card information only for the most recent card (field: ISSUEDATE). Here is a very bas...
Thanks, for your help, I posted a simplified version of my problem but I really didn't understand how to apply the left join in the big one that is this: SELECT d.type, d.item , if(d.type='I', a.name, b.name) as name, if(d.type='I', c.price,0) as price, if(d.type='I',if(d.taxes='yes', (c.priceWith...
I have a php page which allows a user to sort pieces of information by several factors. A new requirement is to sort by "all items which have been registered in the last 15 days". I store my dates in the MYSQL table as mm/dd/yyyy. The information is passed and picked up on the same page using the $_GET variable but I am unable for some...
Hey guys, I've been bashing my head around for hours now, over this login script. It's the one I always used, and I know it works on my version of MySQL. It just won't send me through to the correct authorized page, it will always redirect to the "login_failed.php" file. Any help is much appreciated. <?php ob_start(); $host="localhost"...
I have a correlated subquery that will return a list of quantities, but I need the highest quantity, and only the highest. So I tried to introduce an order by and a LIMIT of 1 to achieve this, but MySQL throws an error stating it doesn't yet support limits in subqueries. Any thoughts on how to work around this? SELECT Product.Name, Prod...
is there a difference in the way this functions between the two databases mysql and sql server: SELECT @@identity ...
I want to write a JavaFX program with Database Connection(MYSQL). I did not know how to create a connection in program. And the methods I found on internet is not working for me. (Possibly because of the version difference or something.) Can anyone give the procedure to establish a connection and run a query from the program for the late...
i am currently calling SELECT @@identity from VBA in mysql: Set rs = cn.Execute("SELECT @@identity", , adCmdText) but since i am going to be working with sql server db instead of mysql, i would like to know how to make this statement sql-server friendly would it just be Set rs = cn.Execute("SCOPE_IDENTITY()", , adCmdText) ?? ...
Can I connect to a ubuntu server, that is running mysql using ado.net or do I need a special driver? ...
Hi all, I'm working with two databases, a local version and the version on the server. The server is the most up to date version and instead of recopying all values on all tables from the server to my local version, I would like to enter each table and only insert/update the values that have changed, from server, and copy those value...
I'm currently working on a sample application in java. I haven't really used java for much more than hello world before so please bear with me. I've set my application up so It's polling a mysql database for information. The issue I have now has to do with updating the content in the frame. Currently I have it opening a new window with t...
in mysql it is possible to do show create table tablename what is the sql server equivalent? ...