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!

Search results for query: *

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

    Batch UPDATE with DELETE function

    Hello all, I'm not sure whether this question should be for this forum or should it belong to SQL forum, so please bear with me here... rs.MoveFirst while not rs.eof ProductID=rs("ProductID") if Session("esku") = 1 then rs("SKU")=Request("SKU" & ProductID) end if if...
  2. A1Pat

    Bulk Update set up

    Hi all, I'm creating a page that I can be able to do bulk updating a whole bunch of data at the same time. So far I'm having a page with all data displayed in edit mode, but I can seem to figure out how to update all of them once I hit Update button. I'm asking this question in this ASP forum...
  3. A1Pat

    Form name in a function

    Hi all, I'm trying to modify this original function that is used to open a form when called: function Do_Connect() { mySDK.WESPSDKMonitor.ClientPullingMode = 0; mySDK.WESPSDKMonitor.Connect(); } and as you can see, the form name "mySDK" is located right in the beginning of the 2 lines...
  4. A1Pat

    Clip off a String

    Hi, I know I saw someone in here show how to do this before which is collecting a string of text without the last particular # of character(s) of that string for ie: Hello World! and I only want to display Hello World (w/o an exclaimation) and I want to use the technique for all other cases...
  5. A1Pat

    execute VB application on IE platform

    Hello all, I'm having an application file, believe to be a VB, and I wonder if there is a way for me to make it as a link so when the link is clicked, a new page will be opened with that Java application to execute. Possibly that we can open a fresh empty page embedding the VB.exe in it, can't...
  6. A1Pat

    Java App.to be a link

    Hello all, I'm having an application file, believe to be a Java, and I wonder if there is a way for me to make it as a link so when the link is clicked, a new page will be opened with that Java application to execute. If it is doable, please show me a way. Thanks!
  7. A1Pat

    Split an array in JS

    How can I translate this ASP code to JS code <% arrChannels = Split(Session("cam_no"), ",") For Each strOneWord in arrChannels response.write strOneWord & "<BR>" Next %> To simply explain the ASP code on the above, all it does is to take a string (ie: 1,2,3,4,5) and...
  8. A1Pat

    Display multi cameras

    Hi all, I'm doing a modification on this pre-existent javascript code and wonder that if anyone can help me elaborate this Single Cam Display to Multi Cam Display... function Do_PlayVideo() { m_chNum = Channel.value; m_frameRate = FrameRate.value; m_resolution = Resolution.value...
  9. A1Pat

    Select Count Group By

    Hi all, I'm trying to get data from my database with this code mySQL = "SELECT Count(*) AS total_count FROM tblTechSupports " _ &" WHERE DateTime = '" & get_day & "' " _ &" AND charged = 1" It works fine until I want to add another field into this code like: mySQL = "SELECT...
  10. A1Pat

    Get DISTINCT DateTime

    Hi all, I'm trying to find a way that list DISTINCT Year(date) from a database simpliest. Here is how I came up: 'Get Years for Monthly Report sql = "SELECT DateTime FROM tblTechSupports ORDER BY DateTime" set rs = objConn.Execute(sql) x = "" if not rs.eof then arrYears = rs.GetRows() end if...
  11. A1Pat

    Syntax error in INSERT INTO statement.

    hi all, I'm getting this error: Microsoft JET Database Engine error '80040e14' Syntax error in INSERT INTO statement. and this is where the error indicates, sql = "INSERT INTO tblCustomers(custName, password, idLoc, channelNo, active) VALUES(" & _ "'" & custname & "', '" & password & "'...
  12. A1Pat

    ObjConn.Open WHERE?

    Hi all, I'm helping my brother creating a small online Access database and integrating it into his free ASP hosting server. The problem is that I don't know exactly the whole directory so I do this: set objConn = server.createobject("adodb.connection") objConn.Open "DRIVER={Microsoft Access...
  13. A1Pat

    What this code is for?

    Hi all, I'm doing a modification on a given example code by adding another TextBox and Label into its form, but it keeps return an error asking me for this line which is located on way top of the page's code: <%@ Page language="c#" Codebehind="Login.aspx.cs" AutoEventWireup="false"...
  14. A1Pat

    Form Submitted

    Hi all, I'm doing a form and having a small question that hoping someone can provide a better idea for me to get to how I want my form to do after submitted. Right now, all I can do is response.redirect the form to itseft with a note says Thank You!!! in order to avoid the form keeps...
  15. A1Pat

    Close() not found

    Hello, I'm getting this error message: System.MissingMemberException: Public member 'Close' on type 'OleDbCommand' not found. And here is my db code dim dbconn,sql,dbcomm dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & server.mappath("database/store.mdb"))...
  16. A1Pat

    REFRESH problem after form submitted.

    Hi all, I'm doing a feedback form exercise and having a little problem when submitting it, that is when I refresh the page (after submitted), the mail keeps sending to me even I'd alread clear up all fields manually. I even do a redirect that take me back to this page again after submitted...
  17. A1Pat

    convert to DropDownList

    hi all, I'm doing this exercise displaying data from XML table to DataListControl <%@ Import Namespace="System.Data" %> <html> <head> <title>Sample Page using VB.NET</title> <script runat="server" language="VB"> Sub Page_Load if Not Page.IsPostBack then 'load XML file to DataSet' dim...
  18. A1Pat

    JS problem when convert from ASP to ASP.NET

    hi all, I'm hitting a impasse trying to convert ASP code to ASP.NET, and one of the line that central of the attention is: <a href="label_sample.aspx?img=Big-O-Tires-Label-BigSample" onClick="return popup(this, "gloss")" target="_blank"><img src="images/Big-O-Tires-Label-Sample.jpg"...
  19. A1Pat

    FSO problem

    Does anyone know how to fix this problem which locking up my laptop when I try to open a webpage located locally in a inetpub/wwwroot/? I know pretty sure that the lock-up was caused by a new page which I created to do GetFolder utitizing Scripting.FileSystemObject, and now, when I close the...
  20. A1Pat

    GetFolder problem

    Hi all, I'd learned how to create a photo album utilizing GetFolder technique instead of what I used to do before through database and recordset calling. Problem is the page is working fine on my desktop but lookup while opening on my laptop. (Both are located in the /inetpub/wwwroot folder...

Part and Inventory Search

Back
Top