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 strongm 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. Shaggs

    PC wont finish counting ram

    the pc had 2 sticks in it and whether i put them both in or either one at a time the same thing happens, just counts to a different number, one less than the amount in at the time. seems wierd that they'd both go at the same time. i might try and get my hands on some more just the same. thanx mate.
  2. Shaggs

    PC wont finish counting ram

    Hi, The pc's a celeron 700. No matter how much ram is in the pc it counts down to 1 less than the amount in there at the time and then freezes. can't get into bios can't do anything. more or less everything has been disconnected except power supply and on change. Has anyone experienced this...
  3. Shaggs

    XML CDATA Entity Problem

    I'm using an XML objects sendAndLoad method and transversing the returned document using another xml object. Perhaps this problem i'm having bears no relation to the flash xml classess but rather a server side problem MSXML2.DOMDocument's CDATA tag converts these characters, so they dont...
  4. Shaggs

    XML CDATA Entity Problem

    G'day, I'm getting data from a web service style ASP page using an XML Object and whenever i get the xml back into flash all the special characters in the cdata/text nodes have been converted into entities e.g. < converted to &lt;. This is a problem as i'm getting html text from a db and...
  5. Shaggs

    Optional Parameters in Functions

    can you have optional parameters in sql server functions?
  6. Shaggs

    form action property not supported in IE

    i have a form which based on the object that is clicked would like to change the form's action and target properties. This works fine in Mozilla and Opera but IE (ver 6.0) throws an error stating it doesn't support this property or method. Any pointers or anyone else had this problem?
  7. Shaggs

    Unicode fonts not displaying in recordset

    have you tried setting the page charset in the head of the page. I'm not sure what the greek charset is. Try finding out the relevant greek charset and replace the following with it. <pre> <head> <META HTTP-EQUIV=&quot;Content-Type&quot; content=&quot;text/html; charset=iso-8859-1&quot...
  8. Shaggs

    Best Practice

    just to add my two bob. this article may be relevant although mostly concerned with ado and very large recordsets. http://www.somacon.com/aspdocs/ I have had to build a few dynamic reports with a Table Of Contents at the start. so i built the entire report out of various strings worked out the...
  9. Shaggs

    Stored Procedure with Parameters

    sorry to add a totally obvious suggestion but your using the adVarChar and AdParamInput ADO constants have you referenced the typeLibrary. Try using thier respective literal integer values. If thats totally left outfield. then i suggest write the parameter to the screen prior to execution...
  10. Shaggs

    Expected 'End' error. HELP!!!

    you need to use the key word 'values' not 'value'
  11. Shaggs

    how to join two Fields

    Is this what your after select aircon1brand from Facility where aircon1 = 'yes' union select aircon2brand from Facility where aircon2 = 'yes' order by aircon1brand
  12. Shaggs

    how to join two Fields

    that's cause that's all that was specified in the select statement with the Left join try somthing like select case when brand1.aircon1brand is not null then brand1.aircon1brand else brand2.aircon2brand end. from ....... To be honest I'm not really sure what you're trying to achieve. Be specific.
  13. Shaggs

    how to join two Fields

    join them giving each of the facility tables aliases select distinct brand1.aircon1brand from facility brand1 inner join facility brand2 on brand1.aircon1brand = brand2.aircon2brand the join i gave here will only return those brand names that are in...
  14. Shaggs

    Error with array

    I'm not sure if you can guarentee the courseID (&quot;CID&quot;) sequential. but for flexibility sakes i'd probably make a 2d array somthing like. that way it doesn't matter if you delete a course and the id's skip a few etc. dim courseNames If NOT rsCourseNames.eof then...
  15. Shaggs

    Check if a var has been dim'ed

    probably not, but if your testing for an array you could use isarray(yourarray) returns a boolean.
  16. Shaggs

    Difficult Select, selecting from another table.

    why didn't you make a link table UsersEnrolledClass containing UserID, ClassID. Storing delimeted data in a database doesn't make any sense. I don't mean to be rude of course.
  17. Shaggs

    'First' is not a recognized function name

    try select top 1 fieldname etc.
  18. Shaggs

    ADO Recordsets - More than one open at a time??

    I think you explained it to yourself. just instantiate multiple recordset objects.
  19. Shaggs

    Calling all those outside UKCan anyone test my currency auto selector?

    Current Country Code: AUS Currency To Display: USA I'm from Australia but doesn't show the old Aussie dollar
  20. Shaggs

    Retrieving temp table data from MS SQL using ASP

    Use the ADO Command and Parameter objects to pass over required parameters to the proc and put the results into a recordset.

Part and Inventory Search

Back
Top