General Forum

I have a question regarding on the button and label. i don't know why when the mouse cursor points on the button, i see the button is flirking. is there anyway to make it not behave like that? because i want to highlight the text above the button when i click on it. can anyone help me out . Thank You the code is following:...

How can i collect table information wich i can reuse in a new sql ie select all colomnheaders from table1 (and use this info in a dropdownlist) select columnheader1 from table1. Is there a object i can use to collect al these kind of information THNX newbie gregor

I want to insert records to the table1 from variable and table2, for example: "insert into table1 (column1,column2,column3) from ('abcd',select a,b from table2)" where insert variable 'abcd' into column1, and insert a,b from table2 into column2,column3, how to write the correct insert statement? thanks.

Hi Guys, I have this following table testin: SQL> desc testin Name Null? Type ------------------------------- -------- ---- NAME VARCHAR2(20) SEX NOT NULL CHAR(1) These are the records available in testin table:

i dont know how to make date format like this 12-sep-2005 my script giving me 12 september 2005 pls any body give sajations

Hi, I am using com.ibm.as400.access.as400JdbcDataSource(Jt400.jar) to read data from DB2 on AS400 V5R3. But here binary is not getting translated. when tried on V5R1 it works. ie binary is getting translated. I tried even setting the property translateBinary = true, but no luck. Is there any specific settings required for AS400V5R3.Any...

I want to send email using sql stored procedure.my code is work fine in my local sqlserver account. when I use my online sql server it display this error. EXECUTE permission denied on object 'sp_OACreate', database 'master', owner 'dbo'. EXECUTE permission denied on object 'sp_OASetProperty', database 'master', owner 'dbo'. EXECUTE...

I have asp.net C# web app. it has country dropdownlist.when the page load I want to select current users country. how can I do this? I want to use client side code for this, can I do this using javascript? pl help me.

Recently reinstalled mySQL v1.4 on Win2000. When my Win2000 OS boots up I see the mySQLadmin dialog twice, and then two icons appear in the system tray. I can kill one, and the other continues to do it's job. Tried setting the Windows mySQL service to manual startup and restarted windows - no joy. Any idea what causes this behavior, and...

HI Does any body know how to convert windows style path to posix style path. I need this because i am developing a windows application which actually starts an exe which is developed in unix. The exe only supports unix style of paths. So, i need to convert the path before sending the path to the exe. please help me if anybody know about...

i m developing the site where i wanted to number the search result pages . like 1 2 3 4 5 next lastpage my code is working if i want to dispaly all from tahe database but my code is not working properly if i wnat to show the search result and numbering those pages.if any body could help. it would be great thanks

'********************START OF BAS MODULE******************** Option Explicit Private Type OSVERSIONINFO dwOSVersionInfoSize As Long dwMajorVersion As Long dwMinorVersion As Long dwBuildNumber As Long dwPlatformId As Long

I'm designing a site for the emergency medicine interest group at my med school. I've uploaded a very early design at http://www.finchfineart.com/emig/ - what I want to do is have a short text desciption about each link popup in the space where it says "Descriptive text here" when the mouse is over the respective link. How can I do this? -...

I am new to creating scripts and can do basic select and update scripting. I am trying to extract information from an Oracle database. The table is CAT1 and the fields are PART and FSC. I want to extract all lines in the PART field that match the FSC. The part field has a max of 20 characters and the FSC has a exact lenght of 4. I used a...

I am creating an XBox tunneling software and I've got everything working fine the only thing I need now is a way to grab the Xbox's packets I have searched about 19 hours total, and have come up with nothing.. also, XBox's have MACAddresses, so I know that will be helpful in grabbing the packets and the XBox's IP is always 0.0.0.1 if...

I have a dialog which I want to keep open after the OK was pressed. (The input should be read but the dialog should remain open). Erasing dialog.distroy() does not do the trick. Thanks, Tal.

Hello, Someone know why this is don't work: SELECT detail_id, de_id, subjectTXT, urlTXT, pictureTXT, priceSaleNUM FROM storeProductHomepageDB WHERE de_id = 11245 AND (CASE WHEN (parentNUM = 0) THEN lan_id = 0 ELSE (lanParent_id = 0) END) ORDER BY rootTXT

Hello, I've created a dialog by creating a class in which Instead of calling wx.Dialog.__init__ I precreate the dialog and then I create the GUI dialog using the Create method. When I create the dialog's class from another class, I don't know how to retrieve the dialog input. I have a few text fields and can't reach them. I don't mind...

i wonder how can i order my statement interm of "ORDER BY FORMAT(Date, 'mmmm')" with using this it will order by alphabethical but i want it order by month... i had try "ORDER BY FORMAT(Date, 'mm')" but due to at the begining i have "SELECT FORMAT(Date, 'mmmm')FROM TABLE" my actual statement will look like this "SELECT FORMAT(Date, 'mmmm')AS...

Hi, I've been trying (unsuccessfully) to create a dialog and then retreive the input from the user. I will be happy to receive a script that does that (or something similar) so I can learn from it. The tutorials I saw teach how to create the dialog but not read from it. Thanks!! Tal.

Hey Guys !!!! Please help me out....... i have to make a small application using VARRAYS in Oracle 9i.... Can you guys suggest me something good....... Thanks in advance... and hoping for a quick suggestion from all you guys ! :)

Hello All, I have been asked to see if I can help out with some reports that we do at work, by no means am I programmer in any type of way. I have part of it done from help that I have already received but I am stuck on something and I have tried to change the SQL myself but have only been successful at messing it up very well. We deal...

I am writing a program that will display a small blueprint that i have already drawn. It is a metafile, but the format isnt really an issue..It can be any format if I need to switch it to something else to get this to work. Anyway, the print will display in a picturebox. Overlayed onto it, are several textboxes that the user can type in sizes,...

Hello everyone, Please HELP !!!!! I'm facing problem in converting CASE statements into DECODE. As i have PL/SQL 8i, so it does not handle CASE statements. Please send me the solutions . Then basic problem is the CASE has NOT condition i.e. <> ...... and this particularly i'm not able to convert in DECODE. Please send me the solution as...

Could anyone help with rewriting this query? Result of this query will be inserted into a table. Thanks! SELECT tableA.PK, table1.amt, table2.amt, table3.amt, .... table16.value FROM tableA, (SELECT fk, NVL(value, 0) AS amt