madani

I see.nz=isnull in SQL Server .Here is an example: select Total=isnull((select sum(Amount) From MyTable),0) if the value is null ,it will be replaced by 0

Response.Buffer = true Dim objXMLHTTP, xml, text Set xml = Server.CreateObject ("Microsoft.XMLHTTP") xml.Open "GET", "http://www.yahoo.com", false xml.Send text = xml.ResponseText Response.write(text) Set xml = Nothing

nz !!!! for IIF ,use CASE type CASE in the book online documentation to get examples and definition

use sp_executesql function which simplifies dynamic sql queries DECLARE @query NVARCHAR(1000) Set @query = N'set @CountRec =(select count(RemainingAmount) from qryReportsInstl where ' + @strWhere + ')' EXEC sp_executesql @query, N'@CountRec float output', @Cou…

can you discribe the error u are getting ?

CREATE PROCEDURE DateString @Mydate datetime, @MySeparator nchar(1) AS select cast(datepart(yyyy,@Mydate) as nvarchar(4)) + @MySeparator + cast(datepart(mm,@Mydate) as nvarchar(2)) + @MySeparator + cast(datepart(dd,@Mydate) as nvarchar(2)) GO

another thing ,jdialog is not appropriate ,you could have used JInternalFrame

you r declaring listbook outside the event handler,so the same dialog get used everytime which increments the number of jtables.try to declare it inside the event handler

it looks like u using the second constructor not the first.if this is the case then add the highlighted code to the second constructor

Hi , My JBuilder 8 always hang when I try to save.Are you sure that the serial number you gave me is Halal :D

try to dispose the jdialog when it is closed public listBook(Library l) { this.l = l; this.setDefaultCloseOperation(JDialog.DISPOSE_ON_CLOSE) }

You need to write the java plugin address inside your applet tag.This will popup the plugin installation dialog box automatically.To get the plugin tag ,try to run one of the java applets examples that comes with the JDK like: C:j2sdk1.4.1_03demopluginjfcSwing…

before running the jar ,type the following : set path=%path%;c:YourJDKHomebin YourJDKHome should be the name of your jdk folder

Update MyTableName Set MyFieldName = MyNewValue you can add a condition using "Where" Example: Update MyTableName Set MyFieldName = MyNewValue Where Id=1

انا نسيت وضع " عند بداية العبارة وكان من المفترض ان تنتبه اليها.هذه هي العبارة الصحيحة : if xmlDocument.load("http://" & Request.ServerVariables("SERVER_NAME") & "/MENUXML/xml/menudef.xml") then set objNodeList = xmlDocument.getElementsByTagname("HEADER")

if xmlDocument.load(http://" & Request.ServerVariables("SERVER_NAME") & "/MENUXML/xml/menudef.xml") then set objNodeList = xmlDocument.getElementsByTagname("HEADER")

You need to do the following in order for the system to detect the java compiler : Control Panel->System->Advanced->Environment Variables->System Variables Look for path in the list and double click to edit it.Add ";" and then your java path at the end,somethi…

تعني انك مستشار معتمد لدى الفريق العربي للبرمجة :D لا تقلق فالمو اضيع التي كتبتها لا تتعرض للغلق الا اذا كانت كهذا الموضوع الذي فتحته

check the path of the xml document .

برنامج لتصفح الموسوعة العربية للانترنت صممته العام الماضي.فيه مجموعة من خصائص ال Swing قد تفيد من يبرمج لسطح المكتب. البرنامج مع المصدر : http://www.c4arab.com/C4arabMadaniBrowser.zip Madani