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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mickallen

  1. mickallen

    Extracting query information

    Thanks I'll have a look
  2. mickallen

    Extracting query information

    sorry for the delay in replying been away for a few days. Thanks csteinhilber thats great. r937 sorry but no I havn't heard of sql injection, what is it?
  3. mickallen

    Extracting query information

    I'm trying to extract query information from a resultset, the problem is I don't know the column headings as the query is created by the user. I can get the column headings using query.columnlist but can't seem to use this within a cfoutput query. Is there anyway to extract the query results...
  4. mickallen

    Multiple Join advice

    I would appreciate a little advice on the best way to develop an application. I have a number of tables for different job roles which relate to a person table. Each person can have numerous job roles. My problem is whether to use my application to search each individual table where a person...
  5. mickallen

    Can't map network drive

    Thanks jonl711 but still no luck, I'm still getting the same error message.
  6. mickallen

    Can't map network drive

    I have checked the hostname and share name and they are ok. I'm using version 2.2.5
  7. mickallen

    Can't map network drive

    I have started to work through the Troubleshooting techniques and fail when I get to the following section: $smbclient //pogo/public -U user1%secret added interface ip=192.168.1.75 bcast=192.168.1.255 nmask=255.255.255.0 I get an error of: tree connect failed: NT_STATUS_BAD_NETWORK_NAME I'm...
  8. mickallen

    Can't map network drive

    I have just set up Samba but I cannot map a network drive to the shares fron either Windows XP or 2K. I can do a net view \\server and see the shares but the server does not show in My Network Places.
  9. mickallen

    Samba DNS

    I'am new to Linux and networking, I have installed the Samba Server and the deamons are running as expected. But I can't see the Samba Server from the client. I can ping the Samba Server from a XP client using the servers IP address and I can ping the client from the Samba Server again using the...
  10. mickallen

    sub select

    Thanks carlrichey That sorts it!!!! Thanks
  11. mickallen

    sub select

    There are two tables, Portfolio and Users Portfolio User_id Score Course_id 1 20 1 2 75 1 1 50 13 3 80 1 Users User_id Name Branch 1 jack ST 2 tom EU 3 pete ST I need a query that will show all users...
  12. mickallen

    sub select

    I have two tables one contains quiz scores the other contains users. When a user completes a quiz they are entered in the scores table. Firstly I need to select user id's from the scores table based on a particular quiz. e.g. SELECT user_id from scores where quiz_id = 13. I then need to...
  13. mickallen

    Finding database size

    Can anyone tell me if it is possible to identify the database size of a MySQL database stored on a remote server, maybe by using SQL? Thanks Mike
  14. mickallen

    Coldfusion and Microsoft Word

    Is it possible to use coldfusion to use the content pulled from a database and save it to a Microsoft Word file.
  15. mickallen

    Web Services

    I'm just testing some of the Web Services at XMethods and I dont know if I'm missing something. I can get some of them to work but others I keep getting the same kind of results e.g. com.serviceobjects.www.WhoIsInfo@2cd728 The '2cd728' changes everytime I refresh the browser window. The...

Part and Inventory Search

Back
Top