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 Mike Lewis 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: contactop
  • Order by date
  1. contactop

    What is MQ Series Integrator?

    Hi, I hope so that u would have got information by now, but more info can be got at www-3.ibm.com/software/ts/mqseries or www-3.ibm.com/software/ts/mqseries/ platforms/integrator this is the best place. Ok, in breif i would only explain in a manner in which u try to make the other application...
  2. contactop

    How to get current NLS_DATE_FORMAT?

    Hi, You can wirte a procedure with a if condition checking the country and then accordingly you set the NLS_DATE_FORMAT create procedure ppp (country as VARCHAR) begin if country = 'XXX' then SET NLS_DATE_FORMAT = 'mm/dd/yyyy'; elsif .... SET NLS_DATE_FORMAT = 'dd/mm/yyyy'; end if; end...
  3. contactop

    ASP and MS Access

    No, the no of connections wont be a problem :)
  4. contactop

    How to see each message in the queue ?

    please elaborate your question. i am not getting it
  5. contactop

    sql help - multiple item/line query

    be clear in your question (put a sample)
  6. contactop

    Generic stored proc

    no, the btter way is have different procedures, as out them up in a package, this not only gives u access rights of the user to control. Yaa, if still u want to continue off, then u can write it. but that will be very much cucumbersome. as one is updateing, other is inserting etc.. bye
  7. contactop

    Connect to remote MQ Server with VB

    this is the code that i am using to connect to a queue manager. Dim gHconn As Long Dim gHobj As Long Private Sub Form_Load() Dim CompCode As Long Dim Reason As Long '========================= 'Initialize the structures '========================= MQ_SETDEFAULTS...
  8. contactop

    How to see each message in the queue ?

    it is very easy doing this. Go to MQseries Explorer, and open the queue manager ,and click the queue folder, which displays u all the quesues on the right side. Double click the queue u want to see, and see all the messages. u get all information. About seeing the data, u double click any one...
  9. contactop

    Email form but edit email before sending

    yes, when u submit your form , then what u do is update the datanbase, and pass the data in another screen with the data, so that the user can edit it. Then have another button "SEND" and he will send the mail, and then redirect him to the page u want. That is how we do.
  10. contactop

    ADODB connection vs. ODBC

    use ADODB connections, as Excel is also from Microsoft, which will allow u to use the ADO obkject model in Excel aslo.
  11. contactop

    Need SQL Help please

    hope the above code by carp works for u.
  12. contactop

    Filtering a database query using a drop down list

    I think this code would get u the Drop Down with the data. <% Dim rsItems strSQL = &quot;SELECT * FROM Item &quot; Set rsItems = Server.CreateObject(&quot;ADODB.Recordset&quot;) rsItems.Open strSQL, objConn rsItems1.open strSQL, objConn If Not rsItems.EOF Then Response.Write _...
  13. contactop

    TRIGGER FOR INSERT

    here is the code from what i have understood create or replace trigger john_labor before insert on labor for each row begin if inserting then if :new.laborcode is null then :new.laborcode:=substr(:new.name,1,4)||substr(:new.rowstamp,1,4); end if; end if; end; insert into labor...

Part and Inventory Search

Back
Top