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 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: *

  • Users: winston1983
  • Order by date
  1. winston1983

    many-to-many query construction

    I would remove the many to many relationship and add a bridge table in the middle. have two fields in it and they should be the topicID and the videoID. this is like a table which makes a one to many relationship from both sides but allows many to many actions. hope this helps. Regards, Lewis...
  2. winston1983

    SQL Extracting more data than I whant

    Has that worked? Regards, Lewis Harvey lewis@lharvey.com
  3. winston1983

    instance of form does not pass values to another form

    Are you sure the form2 frm2 = new form2(); actually links to the form. when you initialise the form do you not have to tell it which form it is looking at, not sure if that initialisation technique works. Regards, Lewis Harvey lewis@lharvey.com
  4. winston1983

    SQL Extracting more data than I whant

    It is returning al the values because you are not filtering down the CAS product type in the main query. Try something like: SELECT * FROM TblMainData WHERE ProductType = 'CAS' AND DateProcessed = NULL AND M.FIRefNo IN (SELECT T.FIRefNo FROM tblTopFI WHERE ProductType = 'CAS'); I think that...
  5. winston1983

    instance of form does not pass values to another form

    do you need to put string s = frm2.sform2.value or .text? so its know what to look for. string s = frm2.sform2.Text; <-Think this is the right one. string s = frm2.sform2.Value; Let me know if it works Regards, Lewis Harvey lewis@lharvey.com
  6. winston1983

    instance of form does not pass values to another form

    Are you posting or getting the form? Regards, Lewis Harvey lewis@lharvey.com
  7. winston1983

    SQL Extracting more data than I whant

    What are you actually trying to get? Regards, Lewis Harvey lewis@lharvey.com
  8. winston1983

    Setting column restrictions in a dataset

    try this link, may be useful to you: Microsoft Validation Controls Regards, Lewis Harvey lewis@lharvey.com
  9. winston1983

    saving asp into a text file

    we need a little more info than that, code? How much HTML code, one file or two, etc Regards, Lewis Harvey lewis@lharvey.com
  10. winston1983

    ASP.NET, XML, web service question, HTTP GET

    If you are working in Visual Studio .Net, right click the project, and then click Add Web Reference. Give the link to web service, I have don't done it any other way but it must be posible. Once you have created the web reference treat it like an object. Sample code below: create the service as...
  11. winston1983

    hide password in traffic and source

    One simple way would be to set it to a string variable and make it equal to lots of small strings. This will only eliminate bots collecting the password, but people will still be able to decypher it. e.g. dim pword = "p" & "a" & "s" & "s" & "w" & "o" & "r" & "d" Regards, Lewis Harvey...
  12. winston1983

    Access2000/ASP Query problem

    It doesn't like the "". In the sub try initilising the sql first as a string, the placing it in the sub, e.g. sub sqlSelect(conn,sql,rs) set rs = conn.execute(sql) end sub openDatabase(conn) dim sqlsate = "select distinctrow(codeview.section) from codeview" sqlSelect(conn,sqlstate,rs)...
  13. winston1983

    Access2000/ASP Query problem

    When you use your sqlSelect() funtion, you have not put brakcets around the properties. Try sqlSelect(conn,"select distinctrow(codeview.section) from codeview",rs) Does this help? Regards, Lewis Harvey lewis@lharvey.com
  14. winston1983

    Can't create a text file using ASP

    Try this <% Dim myFSO 'this line creates an instance of the File Scripting Object named myFSO SET myFSO = Server.CreateObject("Scripting.FileSystemObject") 'error handling here to make sure that things go smoothly 'if the file does not exist If NOT...
  15. winston1983

    Access2000/ASP Query problem

    can you post your asp code for me? or at least the bit which opens the connection and sets the sql and whn you use the results please. Regards, Lewis Harvey lewis@lharvey.com
  16. winston1983

    Do &quot;unchanged&quot; .cs files get recompiled on each build?

    No they don't recompile on every build, unless you actually Rebuild them. I had a similar problem. Regards, Lewis Harvey lewis@lharvey.com
  17. winston1983

    Incorporate New Feed XML

    I don't think you can do it in HTML, you need a server side script to generate parser. I have done it in PHP, but you can use ASP quite as simply. Regards, Lewis Harvey lewis@lharvey.com
  18. winston1983

    Access2000/ASP Query problem

    Have you tried it with Distinctrow? Regards, Lewis Harvey lewis@lharvey.com
  19. winston1983

    Syntax error in response.write statement

    i don't think you can call the method openConnection in the string, e.g. Response.Write is generating a string of text. Try creating a varible set the value of openConnection results and then placing it in the Response.Write criteria. Regards, Lewis Harvey lewis@lharvey.com
  20. winston1983

    multiple recordset or only one

    Thats fine, you can close the recordset instead of using nothing in the first instance. Also, there is no real need to create another recordset (rsEvents1) as once you close the other recordset you can reopen it using different SQL, on the same database connection. Regards, Lewis Harvey...

Part and Inventory Search

Back
Top