Recent content by ro88o

Hi, I have a regular expression that I've created to find code comments in a piece of text which looks like this... (/\*([^*]|[\r\n]|(\*+([^*/]|[\r\n])))*\*+/)|(//.*) If I try to put this into preg_match_all in my PHP script however it returns the error: Warning: preg_match_all()...

Hi all, I'm currently working on a project that creates an XML Document from 'alerts' in my system. A database query is performed and 1000s of entries are returned and then placed into the XML document. The code looks like this: resultSet = statement.executeQuery(SQLQuery)...

Hi, I have a control that is using a custom tree view, the problem that I am having is that when using the 'Windows Classic Theme' in XP (i.e. visual styles are turned off) I get the following error: Visual Styles-related operation resulted in an error because no visual styles is currently...

I'm using the Sybase drivers and I think I may have found what the problem is. Apparently if the version isn't set to 6 then you can have problems with wide tables and truncation, I'm currently working on setting the version but I'm having some problems importing the classes I need :-(

Yep the rs.getString(i) returns the same thing unfortunately. The field type is varchar. Any ideas :) ?

Hi, I have a field in a (Sybase 12.52) database that is 2048 characters and when I run a sql query on a command line it shows all the text inside this field. However, when I run a sql query from java and obtain a java.sql.ResultSet I find that when I do: Object myObject =...

nm solved it.

Hi, If I have a LargeIcon ListView the icons are by default 32x32 pixels. How would I go about altering this to say 125x125? Thanks in advance, Tom

I can't even get that far :( When I type @[trigger name] to compile it doesn't actually do anything, I can carry on typing and/or pressing return and I have to do Ctrl+C and then return to get back to the SQL> prompt.

It didn't work :( Any other ideas ?

Hi, I'm trying to create and compile some triggers in sql*plus but I think I've been given incorrect information on how to compile them. I type EDIT insert_derive_duration and an editor came up which I used to create the following: CREATE OR REPLACE TRIGGER insert_derive_duration AFTER INSERT...

Hi, I'm trying to create and compile some triggers in sql*plus but I think I've been given incorrect information on how to compile them. I type EDIT insert_derive_duration and an editor came up which I used to create the following: CREATE OR REPLACE TRIGGER insert_derive_duration AFTER INSERT...

I'm using an sql*plus with an Oracle database. With the 'as' keyword it threw up this error: inner join groupedon as G * ERROR at line 3: ORA-00905: missing keyword I'd not seen the 'as' used in that situation in my course material so I just removed it.

Thank you so much that's fantastic. Worked a treat (just had to remove 'as' from 'join groupedon as G'.

I have a SQL Query that looks like this... SELECT released_title FROM finishedtrack ft WHERE ft.originates_from IN (SELECT originates_from FROM groupedon WHERE album_id = (SELECT album_id FROM Twenty_People_Info)); What I want to do is display a field called sequence from the...