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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. redtoad

    getElementById Not Working in Netscape

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

    getElementById Not Working in Netscape

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

    Convert varchar to date and sort

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

    Convert varchar to date and sort

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

    Convert varchar to date and sort

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

    Display/Hide Div's

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

    Display/Hide Div's

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

    Building Dynamic Select Box

    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") { //...
  9. redtoad

    Dynamic Parsing of String

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

    Dynamic Parsing of String

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

    Parsing a string to count

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

    Parsing a string to count

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

    I have a record set that has three

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

    I have a record set that has three

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

    Truncated Data

    Thanks, this resolved the issue.
  16. redtoad

    I have a record set that has three

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

    I have a record set that has three

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

    I have a record set that has three

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

    Truncated Data

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

    Evaluate and Suppress Duplicate Rows

    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!

Part and Inventory Search

Back
Top