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 Wanet Telecoms Ltd 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: *

  • Users: ozpeppers
  • Content: Threads
  • Order by date
  1. ozpeppers

    XPClients won't allow log on to server 2003

    Help... The school I work in has migrated to the above spec with AD on the DC but some machines will not log on... A message saying the machine could not connect to the server appears.. I think it has something to do with duplicated machine names but not sure how to fix it... All help...
  2. ozpeppers

    Page can't display images

    Hello peeps, I'm at my wits end here... I'm using windows XP pro with IIS 5 and do you think I can get gif or JPEG images displayed!! Ok... rant over... I can view the images in IE if I type in e:\website\school\images\1.gif However, if I try to relatively or statically link to them in the...
  3. ozpeppers

    IE 5 win 98 applets not showing

    Hi All, I'm using IE5 on windows 98 and cannot display applets... they merely appear as a picture image with no functionality supported. I've checked that the following is turned on in internet options >> advanced: Java Console Enabled Java Logging Enabled Under Security >> Custom Level >>...
  4. ozpeppers

    detecting 404 errors

    Hello, I'm building a web portal that users can submit their sites to. These sites are linked to.. at moment using repsonse.redirect(address) Does anyone know of a way to detect a 404 or similar error and redirect the page back to the portal, so site can be flagged as having an error. Thanks...
  5. ozpeppers

    Return top 5 records

    Hello all, I'm trying to return the last 5 entered records into a table by: SELECT TOP(5) tbl_link.id ,tbl_link.title ,tbl_link.urlPath FROM tbl_link ORDER BY tbl_link.id DESC; Access keeps throwing an error... Does anyone know the correct code? Thanks in advance
  6. ozpeppers

    converting from utc for sql insert

    Hi, I'm trying to insert a date/time into sql 7. The problem is that the variable holding the date/time is in utc format. Does anyone know how to get around this problem? Thanks in advance Mark
  7. ozpeppers

    converting from utc for sql insert

    Hi, I'm trying to insert a date/time into sql 7. The problem is that the variable holding the date/time is in utc format. Does anyone know how to get around this problem? Thanks in advance Mark
  8. ozpeppers

    Convert utc format for sql insert

    Hi, I'm trying to insert a date/time into sql 7. The problem is that the variable holding the date/time is in utc format. Does anyone know how to get around this problem? Thanks in advance Mark
  9. ozpeppers

    Open .pps In PowerPoint not I.E.

    Hi All Can anyone point me in the way to open a Powerpoint File in Powerpoint rather than I.E. Cheers In Advance Mark
  10. ozpeppers

    iframe form won't submit

    Hi guys I've got an IFrame in an asp page which I try to call a function to submit a form: code stored in an <IFrame>: -------------------------------------- <%@ Language=VBScript %> <HTML> <HEAD> </HEAD> <BODY bgcolor=&quot;PaleGoldenRod&quot;> <script language=&quot;javascript&quot;>...
  11. ozpeppers

    Call a Function in another asp page

    Is it possible to call a function in another asp? Mark
  12. ozpeppers

    passing input type=file to new asp page without using form

    Hello Guys I have this file upload problem... I'm using IIS on windows 2000 server. I have a overall form which covers most pages (not my code but it's proving harsh to problem around all the same) and I need to do a file upload... which also uses a form submit... which means 2 forms crossing...
  13. ozpeppers

    concatenating x rows into 1 row

    Hello guys I have a table (table1) with four columns: CustomerID, CallID, NotesID, Notes There are many customers, who have many CallID. Each CallID has many NoteID, ie 1,2,3, each notesID has a one to one with Notes which holds Varchar(255) strings. I.E...
  14. ozpeppers

    Internal Server Error - ASP - Invalid ProgID

    Hi Guys I'm trying to connect to a wsc file from an asp file in the same directory on the server but get an Server object, ASP, Invalid ProgID error. The page below connects to the wsc file. <HTML> <HEAD> <TITLE></TITLE> </HEAD> <BODY> <P> Wrox Building Supplies</P> <P>&nbsp;</P> <% dim...
  15. ozpeppers

    recordset no records?

    Hi How do determine if a sql query generated any records? This is to stop an error &quot;No current record&quot; because no records were generated. ie mySql = Select * from staff; RS.Open mySQL, Conn, adOpenDynamic, adLockOptimistic, adCmdUnknown RS.movefirst - error occurs Cheers Mark
  16. ozpeppers

    SQL data mismatch error

    Hi I'm executing an sql statement and get an error msg - &quot;data mismatch in criteria expression&quot; pointing to the RS.Open line //code mySQL = &quot;SELECT * FROM room WHERE [roomTypeID]like'&quot; & myRoomTypeID & &quot;' AND roomMaxPeople >='&quot; & myRoomMaxStu & &quot;' ORDER BY...
  17. ozpeppers

    hi how do I go about setting up

    hi how do I go about setting up, writing and executing an ado connecting to an access 97 database. The recordsourse being an sql statement used to populate a datalist? Sounds simple and probably is. Cheers in advance Mark
  18. ozpeppers

    adodc recordsource problem

    I wish to locate a record within an access database using an adodc sql statement Is it possible in visual basic to query a access 97 database using an adodc sql select statement with a variable within that statement? i.e. SELECT * FROM comsumers WHERE consumerID = variable there was a...
  19. ozpeppers

    sql problen

    Hi I wish to locate a record within an access database using an adodc sql statement Is it possible to query a access 97 database using an adodc sql select statement with a variable within that statement? i.e. SELECT * FROM comsumers WHERE consumerID = variable Cheers In Advance Mark
  20. ozpeppers

    LAN user or remote user?

    Hi How can i determine a which type of user I have accessing a website. i.e. <% If user = LAN user then userID = Lan Else userID = Remote End IF %> Cheers in advance Mark

Part and Inventory Search

Back
Top