Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Rewrite of a Old MYSql Statement
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. -
Parsing Odd Data
What is the meaning of RHD ALL 23RD? Does it mean that all models starting with a 23 are RHD? -
Parsing Odd Data
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... -
Parsing Odd Data
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... -
Parsing Odd Data
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... -
Parsing Odd Data
Someone else may be able to assist this evening - regrettably I'm out of action until tomorrow. Apologies -
Parsing Odd Data
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... -
Parsing Odd Data
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... -
Parsing Odd Data
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... -
Parsing Odd Data
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... -
Parsing Odd 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? -
-
Only Retrieve Data from 1 Week Ago from a Table
select * from tablename where date_sub(now() interval 1 week) > cast(DateTimeField as Date) -
Group & collapse elements based on field value
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...- jpadie
- Post #5
- Forum: Javascript
-
Group & collapse elements based on field value
Care to share? Easiest seems to be to create a multidimensional object but I am keen to see what you have come up with!- jpadie
- Post #3
- Forum: Javascript
-
-
export appropriate records to .csv file based on querystring values??
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... -
Read / Write and display environmental variable
except in certain circumstances in IE, I believe. (hta files)- jpadie
- Post #3
- Forum: Javascript
-
export appropriate records to .csv file based on querystring values??
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. -
export appropriate records to .csv file based on querystring values??
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...
