Search results for query: *

Hi I'm new to Progress, comming from a SQL background. Does anyone know of any good sites that give examples of writing basic to intermediate queries? thanks

Hi, I'm having a bit of trouble with a query which requires I guess what you call a double left join? the query is:- SELECT p.placementId, p.contactId, p.SBUId, p.placementStart, p.placementEnd, p.workDesc, p.placementNotes, c.conTitle, c.conFirstname, c.conSurname, s.conTitle AS...

Hi, I'm trying out the MVC method but am a bit stuck with displaying results that require iterating through. My model bean deals with database connect and query etc but how can I get a result set to be made available to a view JSP, the resultSet is only available in the model bean as the...

Hi, I am having trouble passing more than one parameter via the URL:- <a href=&quot;http://127.0.0.1:8080/feedback/dispatch?event=1?username=&quot;<%= username %>&quot;&quot;>Display feedback</a> The username has been received by this jsp page and obtained via:- String...

Hi, I have been having problems with UK and MySQL date formats and have been able to resolve most of them so that dates inserted and queried are all ok. However, I have just noticed something strange when attempting to select dates using ORDER BY date ASC/DESC:- SELECT Id, Id2, Title, Type...

Hi, I have been having problems with UK and MySQL date formats and have been able to resolve most of them so that dates inserted and queried are all ok. However, I have just noticed something strange when attempting to select dates using ORDER BY date ASC/DESC:- SELECT Id, Id2, Title, Type...

I am trying to work out how to convert UK date format (DD/MM/YYY) to a format that will be accepted by MySQL (YYYY-MM-DD), so far I have been almost successful by using the following:- $mysqlDate = &quot;1/1/2005&quot;; //split day, month and year into an array $date_array =...

I'm wondering what is the best way to deal with recording/storage of peoples addresses. Scenario:- Table1:CONTACTS conId addressId (FK) fname sname etc Table2:ADDRESS addressId addressLine1 addressLine2 town county poCode 1) A contact may or may not have an address. 2) A contact will only...

Is it possible for a foreign key in a child table to be a secondary key from the parent table instead of the primary key? How would this affect referential integritty , if at all? This is based on the definition that the secondary key is an attribute that will uniquely identify the parent...

Hi, I have been trying to get mail sending from my test server (win2K, running Apache1.3.27, php4.2.3) but just get error:- Warning: Failed to Receive in c:\phpdev\www\project\scismweb\testmailsend.php on line 2 My php.ini has been amended to show the right bits:- [mail function] ; For Win32...

Hi, Sorry if I'm asking this question in the wrong forum, its either SQL or programming and probably a bit of both. I've been trying to work out the best way to do this and would appreciate any advice. Basically I need to have a flag/indicator attribute and am not clear of :- a) the best...

HI, I'm very new to java and have been learning about bound properties but have got stuck trying out a test program which keeps throwing Null Pointer Exceptions. I have mamnaged to bind the text property but have problems with the foreground and font properties, I think this may be something...

I am having a bit of a mare getting this to work, it sort of seems to but then it doesn't!? I have read various articles and the FAQ on this forum but I can't see that I'm doing anything wrong. ([ponder]wouldn't be the first time though!) I have .htaccess:- AuthUserFile...

I am considering including foreign keys using the InnoDB table type but am having trouble setting these up. I've read all the literature provided by mysql but still have problems. Basic table schema is:- # # Table structure for table `company` # CREATE TABLE company ( companyId int(10)...

Hi, I have a table that records contact details as follows:- CREATE TABLE contact ( contactId int(10) unsigned NOT NULL auto_increment, sourceId int(7) unsigned default NULL, companyId int(10) unsigned default NULL, title varchar(10) NOT NULL default '', firstname varchar(20) NOT NULL...

I am having trouble with MS Access and JSP, basically scrip code is:- String query = &quot;INSERT INTO Service (description, regNo, vehicleMileage, serviceDate, totalPrice) VALUES ('Enter details here','&quot;+ regNo +&quot;',0,'01/01/2000',0.00)&quot;; insStmt.executeUpdate(query)...

Can anyone please help, I'm trying to enable InnoDB by editing my.cnf:- # Uncomment the following if you are using Innobase tables innodb_data_file_path = /ibdata/ibdata1:10M:autoextend #innodb_data_home_dir = innodb_log_group_home_dir = c:/phpdev/mysql/iblogs innodb_log_arch_dir = c:/iblogs...