Sulley's Boo

[url]http://i29.tinypic.com/xdaxhv.gif[/url]

[url]http://mysql.telepac.pt/doc/query-browser/en/mysql-query-browser-using-procedures.html[/url] [url]http://www.digitalpropulsion.org/Programming/Stored_Procedures_in_MySQL_5_0[/url]

^ Maybe the OP means Composite key .. -------- You are trying to insert data (PK) which already exists in your table .. this is why you are getting this error ..

[code=SQL]select ID, date, time from tbl where date =(select max(date) from tbl) and time= (select max(time) from tbl) group by ID[/code] ?

[QUOTE=itdupuis;628539]I am 28, and we (friends, family) simply use the brand name. For the most part, the generic terms associated with the description of a softdrink have never been used by us. Now that I think about it, not too many other people take that approach....I do not know how …

^ Gave you +rep by mistake! -.-

I tried the link .. Sorting feature is working fine .. :-/

[code=sql]select to_date(FLD_AS_STRING, 'dd/mm/yyyy') from Table1 where to_date(FLD_AS_STRING, 'dd/mm/yyyy') > sysdate;[/code]

and .. Your table name is 'table'? -_-

Cooking!

My fav. are all listed in here [url]http://www.nipponanimation.com/[/url] Watched most of them (dubbed into Arabic) .. I like watching Tom n Jerry too .. not the Juniors series (eww) ..

<_< Remove the PK (invoice_no, ISBN) from the Delivery table so that you can repeat the invoice_no as much as you want. Think of a new PK for the detail (delivery) table. How about Serial no?

Hiii :icon_mrgreen:

:S and, this line is missing [CODE]pst.executeUpdate();[/CODE] right ppl? *hides*

From version 9i release 2 and on, the column renaming feature works.

gamecube mario party 4 5 6 7 :D :D :D :D ..

*_* nice game ..

[URL=http://www.fancyflours.com/fancyflours/images/large/candles-happy-birthday.jpg]=D here here[/URL]

You are asking urself and answering right away .. nice ..

[CODE]select a.id, a.productname, a.siteprice, b.propertyvalue from product a, productpropertyvalue b where a.id = b.productid and propertyid [COLOR="Red"]in (589, 617, 615)[/COLOR][/CODE] ?

[CODE] EnqSrNo QTypeCode [COLOR="Red"]9 1 9 1[/COLOR] 9 2 9 2 9 2 9 2 9 3 9 3 9 4 9 4 9 4 9 5 9 5 9 5 9 5 9 5 9 5 9 5 [COLOR="Red"]8 1 8 1[/COLOR] 8 2 8 2 8 2 8 …

I float and fly a lot .. feels so good and so real! .. :$

Tea with milk, milk, and water ..

> Well n not a mysql expert so i need help with this sql file here r d contents of it. > > Quote: CREATE TABLE `admin` ( `id` int(11) NOT NULL auto_increment, `username` varchar(255), `password` varchar(255), `webmaster_email` varchar(255), `lastlogin` int(11), PRIMARY KEY (`id`) )"; > "insert into admin set …

[quote][B]Sulley's Boo[/B] Sulley's Boo is a tricycle that can be used by several people at once! It emits dangerous radiation and hovers three feet from the ground. [/quote] :yawn:

Hello, Cherylt. Welcome to Daniweb =D

[url]http://www.codeproject.com/KB/IP/Sending_SMS_using_Net.aspx[/url] :?:

Eset Nod32 ..

google it .. You will find tons of MS Access tutorials .. [url]http://www.bcschools.net/staff/AccessHelp.htm#CreatingOpening[/url] Here is an example .. Hope it helps ..

[code]<?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Connection Error ' . mysql_error()); } mysql_select_db("my_db", $con); $sql="INSERT INTO productlists (prod_number, name, category, type, description, price, pix) VALUES ('$_POST[prod_number]','$_POST[name]','$_POST[category]','$_POST[type]','$_POST[description]','$_POST[price]', '$_POST[pix]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo ""Hit the BACK button to insert another item""; mysql_close($con) ?> [/code] :?: try …

O_o thank God i quited eating junk!

[quote]include("connect1.php"); $table = events; $query = "SELECT id, topic, event, dateFROM events ORDER BY id DESC LIMIT 5"; $result=mysql_query($query); //LINE 140 while (list($id, $topic, $event, $date) =mysql_fetch_array($result)) { echo" <font color=\"#006600\">&nbsp;On ".substr($date,0,10)."</font> <a href=\"$self?page=showevents&id=$id &topic=$topic \" class=\"elibtopic\">$topic</a> [B][COLOR="Red"]";[/COLOR][/B] } [/quote] Why do you need the stuff in red?

[QUOTE=iamthwee;524958]What's is your S*** gonna be? Have you already got someone lined up (Long term relationship). [/QUOTE] No. [QUOTE=iamthwee;524958] If not what are you gonna do about it? Do you even care? [/QUOTE] Couldn't care less.

Not a fan of ice cream .. but those are the flavors that i can swallow Vanilla / Mango / Choco in that order .. mix them together? No problem! Any brand will do ..

Welcome back tayspen [COLOR="Red"]@[/COLOR][COLOR="Green"]--}----[/COLOR]

me me me .. It is not that bad! .. First you will have to do some tests to know the shape of your cornea and its thikness .. and then only they will tell you if you are eligible to undergo this procedure or not .. They will ask …

Adventure, and racing .. but voted for racing ..

[code] To create the usp_InsertGroup stored procedure, right-click the Stored Procedures node and choose New Stored Procedure or click the Database menu and choose New Stored Procedure. Enter the following code: SQL Server CREATE PROCEDURE usp_InsertGroup ( @GroupID UNIQUEIDENTIFIER, @GroupName VARCHAR(50), @GroupDescription TEXT ) AS INSERT INTO Groups (GroupID, GroupName, …

[QUOTE=cscgal;503720]I don't know why it wouldn't open the first time but I got it open ... not sure why you would be experiencing that. Does anyone else experience this issue?[/QUOTE] Yes, but like an hour ago. Everything is back to normal now. :-O

try these SUBSTRING(srting, position, length) [code]SELECT SUBSTR(Column_name,1,200) [/code] [code] SELECT SUBSTRING(Column_name, 1, 200) [/code] or [code]SELECT LEFT(Column_name, 200) [/code] :?: Hope this works ..

Try this :?: [code] SELECT Table1.ddate FROM Table1 WHERE (((Format([ddate],"dd/mm")) <> '26/01' AND (Format([ddate],"dd/mm")) <> '15/08')); [/code]

Help! .. I want to delete this post!

Can you show us your query, please? This should not happen if you have the order by clause in your query .. :?:

Invest the money .. the double/tribble/()*%&$#)%&ipple that ill get from that, ill keep on donating it to those who need it .. and ofcourse I'd save [I]some[/I] for me n ma family :P

Molten Chocolate Cake :$

you are welcome!

This is a JSP forum .. Anyway, use Javascript .. You'll find so many types of dynamic menus in here > [url]http://www.dynamicdrive.com/[/url]

you can set a format mask for the date .. dd-mm-rrrr hh24:mi:ss Have you tried that :?:

I would die to go to Japan .. :*

[CODE]update item set description=(select convert(varchar(600), description from item where itemid=5384);[/CODE] :?: