Search results for query: *

...dropping existing procedure . the syntax : create procedure checkSP (nmSP varchar(200) ) begin declare ada int; set ada = 0; select count(*) into ada from information_schema.ROUTINES where ROUTINE_NAME = nmSP; if ada>0 then SET @S := concat('Drop procedure `', nmSP , '`;' ); PREPARE...

Dear friends, is there someone could help me ... What is wrong with my XSL file which is converting an XML file into fixed-length output ? Because I get 1 empty line before & after the fixed-length data. Here's my XML <library> <book> <style>Z79</style> <title>Judul Judul</title> </book>...

Hi guys, I need a solution here. From DatabaseMetadata is it possible for me to get the inside syntax of my stored procedure ? So far I only can retrieve the Input & Output parameter along with its data type, length, nullable. Pls respond me ASAP. thanks alot *JJ*

...where branch_code =52 open mycur fetch next from mycur into @brcode, @brnm While @@fetch_status =0 begin select @jml =count(*) from eis.dbo.sc_company where branch_code = @brcode if (@jml =0) begin insert into eis.dbo.sc_company (branch_code,branch_name) values (@brcode, @brnm)...

if you want to show the image (after visitors click the thumbnail), i think you can use javascript window.open syntax. of course when you write down the javascript code you need to put complete image ID, so the browser will know which image visitors click. *JJ*

...return, but at the other one i got the correct ones. perhaps my found would help you. this query syntax is inconsistable in my 2 machines Select * from Table1 Where date_format(receiptdt, '%Y-%c-%d') = '2004-1-1' and date_format(receiptdt, '%Y-%c-%d') = '2004-9-24'; then i change the...

Thanks alot for your info. I've read in the manual stating the same procedure as you said. So I guess I have to download the next version of 4.1.X ciao....

I didn't get the errors like you had. I also download MySQL 4.0.21 in winzip package from http://www.mysql.org, but i can't find file install.exe like you had. What I use is Setup.exe. Are you sure you download the right installer ??

...CREATE TABLE t1 (s1 INT, s2 CHAR(5), s3 FLOAT); Here’s how to use a subquery in the FROM clause, using the example table: INSERT INTO t1 VALUES (1,'1',1.0); INSERT INTO t1 VALUES (2,'2',2.0); SELECT sb1,sb2,sb3 FROM (SELECT s1 AS sb1, s2 AS sb2, s3*2 AS sb3 FROM t1) AS sb WHERE sb1 > 1...

Hello guys, kindly please help me with my problems that im having it for abt 1 week, and i can;t solve it. Im using MySQL 4.0.21 and I have 2 tables : [payment] [cashier] id id amtpay stockid subtot [payment].id is...

someone can help me I got this error when starting up my Tomcat C:\Tomcat\bin>startup The JAVA_HOME environment variable is not defined This environment variable is needed to run this program Using CATALINA_BASE: C:\J2EE_1.4 Using CATALINA_HOME: C:\J2EE_1.4 Using CATALINA_TMPDIR...

To save your server processor, maybe you can put some validation (using client script, of course) before Users click the button show DVD. As to examine the value which Users would choose in those of your combo boxes & radio buttons. If the users haven't been set things right, then your...

...set oRSGenres = Server.CreateObject("ADODB.Recordset") set oRSqrydvdlistbygenre = Server.CreateObject("ADODB.Recordset") sqlGenres = "SELECT * FROM tblGenres ORDER BY genre ASC;" sqlqrydvdlistbygenre = "SELECT * FROM qrydvdlistbygenre WHERE genre = 'Foreign' ORDER BY title ASC;" %> <form...

Could you quote some of your code which is going this error?? When you got this error message, the internal msg will anounce the exact line of its error. maybe you can use that as direction to your error ASP page. or you could go to www.microsoft.com site. and search for your error number...

Thanks for the *Star* Anyway, I was thinking abt one other way. Still don't know suit to your needs or not, and intending to know whether it's a better solution (perhaps you can consult with your SQL Developer). Here's my idea : 1. Write an SQL stored procedure that will complete deleting all...

Sharing with you abt the usual way of my coding strSQL = "Select * FROM Investments WHERE ClientID = " & intUserID Set objRS = Server.CreateObject("ADODB.Recordset") objRS.Open strSQL, objConn, 1, 3 'strTableTest = "<table><tr><td><b>i</b></td><td width=""50""></td><td><b>Fund ID</b></td><td...

Glad to hear your success. Thanks for the bright Star [infinity] *JJ* [infinity]

I don't know for sure whether this could be some considerations or not. But If you're using ASP codes. You can export your codes to DLL file. I've read abt this article. But of course there're advantages & disadvantages againt this matter. Abt what I've experienced in Saving an HTML document, I...

Your redirect syntax must have send address something like this (you should see this kind of pattern in your address bar browser): http://MyWeb/rptChaseList.asp?UserID=JJ26&State=1#1313 The sign #1313 means the browser has to scroll down to the specific bookmark (which you've drawn for each...

I guess you can use response.redirect syntax to go back to your first page, especially to your specific record. You're abt to put bookmark in every record ID, right ? That's a good start. Then you just need to put the query string together along with the achor syntax...