Search results for query: *

there is an error. it's not a version thing. this line `crmnow_pdfcolums_sel` . * AS selected first there is a space either side of the dot. i don't recall whether mysql is agnostic to spaces. but mostly you can't select an entire table (*) as a single field.

What is the meaning of RHD ALL 23RD? Does it mean that all models starting with a 23 are RHD?

search believe me - it is entirely relevant. how you want to search must completely lead how you structure parsed data. RHD so it is impossible to have, say 2401;RHD 2402-03-04-05 i.e. RHD must always be first in the field and apply to all models in the field. [b]ALL[/b} i think I'd need...

I was partially prevaricating as the nature of how you were going to search must lead the nature of how you parse out the data. Given the lack of structure it is difficult to see a neat way of constructing a parser. And I am concerned that your statement re the meaning of RHD as a...

I don't think that the parsing is difficult _technically_, it is more the searching that you will have trouble with now. Having said that, however, imposing structure on essentially free form text is seldom straightforward from a business rules context. Particularly so when your last post...

Someone else may be able to assist this evening - regrettably I'm out of action until tomorrow. Apologies

You need the index for searching. The error was that indices cannot take an if not exists declaration. So of you delete that you should be fine. Likewise you should not need to drop the table as the queries will just error for those rows that are already in the table. But there is little...

i see. it is going to be difficult to cater for OCR errors as well. but try this and see what output you get <?php $query = <<<SQL select partNo, models from oldTable SQL; $createQuery = <<<SQL CREATE TABLE IF NOT EXISTS p_m_b ( partNo varchar(20) NOT NULL, modelNo varchar(8) NOT...

i spent five minutes writing a script for you. one anomaly i cannot solve from your explanation is the significance of 2501 in this L422445 2401 (BODIES 2462 2465 2492 2415 2498): 2501 I suspect that the 2501 will be another modelNum. although I can't see a reason why it is delimited by a...

Oh. I had not made that assumption. So that series will actually be 2206 2213 2226 2233? If so then a regex query will allow you to search accurately. And a like query will get you close. But it looks overall better to restructure the table and do a one time expansion of the textual data...

Why does this 2206-13-26-33 Expand to 2206 2613 2626 2633 Ie where is the logic that says transform 22 to 26?

oops!

select * from tablename where date_sub(now() interval 1 week) > cast(DateTimeField as Date)

i'd do it very similarly in php. that's what I meant by a multidimensional array. then I'd deliver it as json and let a javascript widget do the DOM interaction. something like this class would do very well (although it would only take five minutes to write your own anyway). the easiest...

Care to share? Easiest seems to be to create a multidimensional object but I am keen to see what you have come up with!

Just add css classes or inline style declarations.

the point here is to show you how to debug in php. your first post made clear that your error was in the query. so i told you this and suggested you check the error back from the database. you could have checked the manual for how to do so. then i showed you the code that would tell you the...

except in certain circumstances in IE, I believe. (hta files)

i guarantee there was an error in the query. you must test for that. your code did not do so. whether the error derived from your use of strpos or not is irrelevant. the error was in the query. that is the only way that php will return boolean false rather than a resource.

you've posted the php error for the fetch. not the database error for the query. if(FALSE !== $x = strpos($strTypes, 'bidDate')): $sql = " SELECT c.* FROM ( SELECT ROW_NUMBER() OVER(ORDER BY ID) AS RowID, CONVERT(VARCHAR(11), b.BidDate, 106) BidDate...