Search results for query: *

Ok, I'm officially an idiot. Thanks for the extra set of eyes.

This function works in IE but not Netscape or Mozilla. Doesn't seem to be evaluating getElementById in Netscape or Mozilla. The function getStyleObject(objectId) returns false for Net. and Moz. I have several div's that will show/hide according to the option box selection. Here's a snippet of...

I made a mistake on my post, should have been Select Cast(fieldvalue as datetime). As for the date being varchar...this is an issue that comes up time and time again. We have to account for it in much of our code, but there are always places that have been missed. I don't know that it will...

I was able to acheive the desired result by: Select fieldvalue as datetime from data where fieldID = 289 order by Cast(fieldvalue as datetime) Thanks for the help. I guess I was making it too complicated.

I am trying to return a varchar converted to date. Then I want to sort by the date. Returned values vary, some are 02/01/2004, some 2/01/2004, etc. This is causing sql to not sort the way I want. I would like to sort chronologically by year, then month, then day. Here's my query Select...

I got it working. This was a modification to a page that didn't use div's before, so the issue was I broke up the pre-existing table tags, and the div's weren't displaying properly. So I created new table, tr and td tags and now it is displaying correctly. Thanks for the response.

I have a page with a select box. The select box is defaulted to index 2, and it's corresponding div. When the user makes a selection from the select box, the previous selection's div should disappear, and the new selection's div should display. However, the new div is appearing below the old...

I am trying to create a single select box based on a dynamic array. However, it appears that only the last value in the array is populating the dropdown. Any help would be appreciated. Here is a snippit of the function: if (questionsArray[i].questionType == "Drop Down") { //...

Thanks for everyone's input, each response was helpful. I ended up using something very similar to gavinhuet's response. Thanks again.

This query - DECLARE @Note varchar(255) SELECT @Note = NoteText FROM Notes WHERE RecordID=5173 Returns the following string: Please review and provide feedback.<br><br><a href=test>Candidate cjtest54r jtest54r</a><br><br><a href=test>Candidate cjtest08r jtest08r</a><br><br> I use the...

Thanks stravis and swampBoogie, that's just what I was looking for.

I need to get a count on the number of values in a string. For instance, my query returns something like this: '1000,2000,3000' I need a count of 3 returned (as a varchar). Or if the data returned is '1000', I need a count of 1 returned. Any help would be appreciated.

Thanks for your patience. I followed your advice and the only issue was the Name and Number fields did not show up on the second line. I solved this by putting the name and number data fields in detail section a, b, c and put field1 in a, field2 in b and field3 in c. I then used conditional...

Let me try to explain how the report is generated in the application I'm using. Disregard the joins. I write a SQL query, and put it in the client's version of my company's application. The query can consist of the standard keywords, such as selects, joins, creating temp tables, etc. Our...

Thanks, this resolved the issue.

My formatting on the above recordset was a little off, it should appear like this: Name Number Field1 Field2 Field3 John Smith 100045 Sales Customer Support

My record set will appear like: Name Number Field1 Feild2 Field3 John Smith 100045 Sales Customer Support I need the report to appear like: Name Number Department John Smith 100045 Sales John Smith 100045...

I have a record set that has three rows per person. All of the columns and rows are the same except for the last column. The first line will have field1 in the last column, the second line will have field2 in the last column and the third line will have field3 in the last column...

I am sporadically seeing truncated data using Crystal 8.5. The recordset returns the full data, but when I view the data in crystal, it is truncated. It doesn't happen everytime or on all fields. I searched the knowledge base and found an issue where using a font of less than 12pts. can cause...

Yes, it's working now as intended. I was still using option a in my previous posts. Option b with your additional suggestions got me the correct display. Thank you!