Hi I have a field which has a carriage return in it. because of this it wont search this field properly and will not display any matching results. How do you deal with carriage return fields so that I can query them? thanks

Ive replaced the apostrophies and it doesnt show an error message but now it just wont find that field which is weird. The sql statement is searching a table for fields that match the description the user puts in. Is this because the apostrophies are not recognised in the field? thanks OK forget what I said above. I think the problem is that there are breaks in the text in the database field, i.e. a new line so this might be causing the error of not finding it. Is this a known problem when searching database fields that if there is a line break in the field it affects finding data? thanks

modified on Monday, June 29, 2009 8:26 AM

Hi I am using inline sql to search a table column. Some of the fields in the column have ' ' in them and whenever these fields are chosen it shows an error 'In correct Syntax near the text that is in the ' '. Is this a problem because it affects the sql syntax in the statement? My code goes something like 'select from table where field is LIKE '%" + name + "%'" Any help would be great. thanks Jamie

Ah sorry didnt see it. :-O

Woman drops tool bag in space

Imagine if you voted for him, you would be a tad annoyed wouldnt you?

Paul Watson wrote:

I disagree.

So if that happened to your child what would you want to happen?

J4amieC wrote:

Lets just hope whatever prison guard is looking after them knows how to boil a kettle - and I dont mean to make a nice cup of tea!

And also has a bag of sugar at hand as well.

stop moaning and sock it up...

:-D

Typical. They should be looking at what you can do rather then just judging on the amount of experience you have. You could have 5 years experience and still be not as good as say someone who had 2-3 years experience.

I had to do a maths test for a programming interview once. It was so stupid. I had to identify patterns in drawings for example if a square has a triangle in one corner and the next picture is slightly different etc. The guy said it doesnt prove that Im not a programmer if I dont pass it just proves if you are suitable for our job. Why cant they keep it simple and just ask us to write a few lines of code!!

Planes Collide

Yeah you are right.

Mycroft Holmes wrote:

What do you call 1000 lawyers at the bottom of the sea

A job well done.

Add to reference library maybe?

Rage wrote:

I asked the question here a while ago, and almost everybody said it lacks essential features and is not worth looking at.

Don dismiss it so easily, I use VWD Express it is good. The Express editions are useful and are well worth a visit.

So you want to only show the error message when the login is not in the database. If they dont enter anything and click a button you want a required field validator to fire, is that correct? Just add a required field validator to the control and that will check if the field contains a value.

Maybe the First and Prev buttons have been layed off what with it being hard times because of the current financial situation. I hope they got a good redundancy package.

Phannon wrote:

So going from having never programmed before in my life, then after completing a 3 year uni course in computer science, getting my 2:1 in what may as well have been a Java degree (it was heavily based on Java, but there were other aspects to it)

Sounds like my uni degree. They concentrated on java for the first 2 years, went on my placement and learnt c# came back did java, got my 2:1 and then started job doing c# again. Never done Delphi though.