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 TouchToneTommy 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 jotap

  1. jotap

    Function Problem

    Hei, don't get me wrong. I'm very thankful for your help. All of you. I was just trying to understand because unfortunaly i'm new in programming.
  2. jotap

    what's best for performance????

    I'm developing a webstore application for e-commerce(or trying to :-p ). I'm wondering about the best way to get some values from my database. I have Categories, Families and SubFamilies. Now each time i load a page, depending on the page level, the server has to load/unload around 5...
  3. jotap

    Function Problem

    basically the code is the same but with debugging. I don't understand why it works only now. what do you think?
  4. jotap

    Function Problem

    It's working............... i've tried the code and it worked. thanks a lot. But just to understant, what or where was the problem the way it was???
  5. jotap

    Function Problem

    here's one problem: I've tried: Response.Write "<BR>Entered GetMarca with Codigo=/" & Codigo & "/<BR>" and i got: Entered GetMarca with Codigo=/1/ Entered GetMarca with Codigo=/1/
  6. jotap

    Function Problem

    Yes it is
  7. jotap

    Function Problem

    to sheco Are you running this from a web server or as a .vbs file? i'm running fro a web server. I dont see you open the connection, is this a global variable connection? it´s an include .asp file
  8. jotap

    Function Problem

    it still doesn't work(SLQMarcas = SLQMarcas & "WHERE Marcas.Cod=" & CLng(Codigo) i've also tried to convert to string, integer...
  9. jotap

    Function Problem

    No, the field is correct (Marcas.Cod) and it's an auto_increment field. i've tried to use the code in a separate asp page and it work's fine. Here's the code working: <!--#include file=Conn.asp--> <% Dim SQLMarcas Dim RSMarcas Dim Cod Cod = 1 SLQMarcas = "SELECT Marcas.Nome "...
  10. jotap

    Function Problem

    ok the real code: Function GetMarca(Codigo) Dim SQLMarcas Dim RSMarcas SLQMarcas = "SELECT Marcas.Nome " SLQMarcas = SLQMarcas & "FROM Marcas " SLQMarcas = SLQMarcas & "WHERE (((Marcas.Cod)= " & Codigo & " ));" Set RSMarcas = Server.CreateObject("adoDB.recordset") set RSMarcas =...
  11. jotap

    Function Problem

    here's the function code: Function GetName(Code) Dim SQL Dim RS SLQ = "SELECT manufacturer.Name " SLQ = SLQ & "FROM manufacturers " SLQ = SLQ & "WHERE (((manufacturer.Code)= " & Code & " ));" Set RS = Server.CreateObject("adoDB.recordset") set RS = Conn.Execute(SLQ) if err.number...
  12. jotap

    Function Problem

    Hi there...! I have a problem when calling a function that returns a recordset value. Here's my problem: sub main ... call WriteCatalog(rs("productname"),..., GetName(rs("manufacturercode")),...) ... end sub sub WriteCatalog(prodname,...,manufacturer,...) response.write...

Part and Inventory Search

Back
Top