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

Doh!! Spotted my mistake, should have been:- LEFT JOIN contact s ON p.SBUId = s.SBUId You just never can check enough!! Still someone might find post useful[yinyang]

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...

Looks like fun that I'll have to save till later I guess. cheers for all your help though!

Sorry if i've got this wrong but..... I have a Control bean that has the doGet and doPost methods which does not query the database at all, this is done by the Model bean. If I include all the necessary code to try as you suggest then this will no longer be MVC? I can understand the reasons...

????? Not that good at java, i'm afraid. thanks for your help anyway:)

This may sound stupid but how will I be able to obtain specific data values as the ArrayList or whatever won't know like a ResultSet object so I can no longer use rs.getXXX. Or am I missing something?

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...

It's ok, I didn't really think that you did, but extempoblahblah actually means "spoken, performed, done, or composed with little or no preparation or forethought" and I only do that when I'm drunk,...... I think:)

Thanks, I eventually found an example and spotted my error after many hours!! ps. its extemporaneous, but the context doesn't fit here, unless you meant to insult me? ;)

sorry, I of course meant:- <a href=&quot;http://127.0.0.1:8080/feedback/dispatch?event=1&username=&quot;<%= username %>&quot;&quot;>Display feedback</a> that is with 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...

I can be incredibly dumb sometimes it scares me!! [blush] thanks

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...

Sorry, Please forgive the title of this thread. I have reposted under DATE_FORMAT() ORDER BY. bit trigger happy today I guess! [wink]

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...

Thanks Missy Ed, I think I can definately say if its not £0.00 then its not going to happen. K.I.S.S?

Thanks Craig looks as though this could be a be a good alternative in some circumstances. Trouble is if you don't have a postcode to enter then you can't enter the record:( I'm new from the world of academia so am finding out that not all they teach is best (well I kind of suspected that anyway!)

Thanks anotherDeclan, as luck would have it I just stumbled accross another forum and found this:- //split day, month and year into an array $date_array = explode(&quot;/&quot;,$mysqlEventDate); //convert to UNIX timestamp format with mktime() and reformat with date() $NewFormat =...

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 =...