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 SkipVought 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. mhenley

    Select Distinct and order by

    Never mind, I figured it out...
  2. mhenley

    Select Distinct and order by

    I'm wanting to use the distinct function to parse duplicate records (in a stored procedure from ADO, but I don't think that is the issue). The problem is that it is not eliminiting the duplicate records??? The following is a sample of what I've tried to do. Some columns in the select and...
  3. mhenley

    APS vs. Info

    I'm new to the Seagate reporting world, so please bear with me.... Can someone provide a good definition of APS? Or better yet, what the difference between APS and Info is? Or is APS a componant of Info? I've had some limited experience with Info but don't really know where APS fits in...
  4. mhenley

    JavaScript error in IE

    Can I see the code where you call the function? I would guess this is where your problem lies (I copied your function into a test page and used an onclick command in IE and it worked just fine). Matt H.
  5. mhenley

    formname.imagename.width/height in Netscape 4.7

    Yo I use the following code to do some evaluation on image size. if (document.frmPrint.image_name.width < *somenumber*){ ... Also use xxxx.height property. Works great in IE5.0 and NetScape6.0, but not Netscape 4.7. I know this probably just isnt' supported, but does anybody know anything...
  6. mhenley

    Drop variable into Request.Form statement

    Don't know if this is what you are trying to do or not but I think what you are trying to do is this: request a piece of data from a form, then use that data in conjunction with something else to test a condition. If this is the case, you should assign the form field to a var then add the data...
  7. mhenley

    Sendmail instructions

    Does anyone know of a good FAQ out there describing how to set up a linux box using a freeware email server (sendmail?). I run a small Win2k only shop, but do not want to spring for the ridiculously overpriced MS Exchange. Thanks, Matt.
  8. mhenley

    Slow Network Browsing

    Don't know if this applies, but I would make sure you are at least running SCSI drives (or even better, a RAID config) in any shared environment. Speedy logins are a sign that DNS/WINS is probably functioning properly. If this is an IDE drive and someone has an open connection to that drive...
  9. mhenley

    Cheap firewall solution?

    UPDATE: We decided on the 3Com OfficeConnect 25 (got it for $545). So far no problems. Unit is very similar in many ways to the LinkSys unit that chiph talks about. We have a LinkSys here that we use with our cable modem connection for NAT, DHCP on our internal network (Web and DB servers...
  10. mhenley

    Cheap firewall solution?

    Hello I work for a small startup company that is getting ready to move our site from the developers office to our office. I want to set up some sort of security to the site but I'm new to the firewall world and need some advice... Here's our setup: A full T1, Cisco 2620 Router, and Win2k...
  11. mhenley

    Where clause in stored proc evaluating varchar

    For some reason this procedure returns 0 records: CREATE PROCEDURE get_association_by_name ( @association_name varchar(50) ) AS SELECT association_id, association_name, association_acronym, phone, city, state, zip FROM association WHERE association_name like...
  12. mhenley

    File corruption over cable modem

    FYI: Cable modem was bad, swapping it out with a new one fixed the problem.
  13. mhenley

    File corruption over cable modem

    Help! My ASP files are getting trashed when I save using InterDev. We have a small hosting company that has the server connected to the internet via a T1. They are able to open, modify, and save files just fine locally. Futhermore, I use dial up and connect to the internet and save files with...
  14. mhenley

    A downloadable trial?

    I bought the SAMS book &quot;Teach Yourself Visual InterDev 6 in 24 Hours&quot;. It came with a CD that had (among other things) a 90 trial version of InterDev 6. Its a pretty good book, bookpool.com had it for under $20 I think. Well worth it...
  15. mhenley

    Cannot open DataEnvironment.asa for read/write

    I'm trying to add a data connection to a SQL DB. Whenever I try to save the Global.asa I get the following error: Cannot add file 'DataEnvironment.asa' to master web application. Server error: Cannot open file &quot;c:\inetpub\wwwroot\_private\DataEnvironment\DataEnvironment.asa&quot; for...
  16. mhenley

    Reboot only option after ASP 0115?

    The people hosting my development boxes tell me that the only way to recover the server after a trappable error is to reboot the server. Is there any other way to clear the trap? Maybe stop and start IIS??? We are developing some real database intensive stuff using tons of stored procedures...
  17. mhenley

    Passing table/column name to stored procedure

    I still get a similar error (incorrect syntax near keyword DELETE) I think you are on the right track though, Malcom. Any other ideas?
  18. mhenley

    Passing table/column name to stored procedure

    I'm trying to pass table and column name to a stored procedure (I have several tables with the same basic structure). Here's what I tried: CREATE PROCEDURE del_loc ( @table_name varchar(50), @col_name varchar(50), @id_to_del int ) AS DELETE @table_name where (@col_name = @id_to_del) SQL...
  19. mhenley

    how to drill down on a table for more info

    You could handle this a couple ways. I would recommend calling page3 with a form instead of href. You could use hidden form variables to pass a record count. You would then use this record count on page three to do your search again, this time giving the full data. Something like this... <%...

Part and Inventory Search

Back
Top