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

  1. jon24422531

    Use an array in a function?

    I am a PHP newbie so please forgive what may be a simple request. I have used PHP and JSON to retrieve a view count for a single YouTube video, but I want to list the view count for many more (around 65) probably using an array. This (predictably) does not work, where am I going wrong? <?php...
  2. jon24422531

    can PHP reload a div with new data?

    Hi I am very new at PHP, and foolishly I've decided to create my own blog.... So I have a database, and I can create new blog entries and then display them on my web page and so far so good. Now down the right column I will have a list of subjects etc that I want a user/reader to click to go...
  3. jon24422531

    Browse a directory on another server

    I am struggling to understand why this does not work and I would appreciate some help. On our Intranet I want to be able to list Word (.doc) and PDF files from a particular folder and enable the user to click the relevant entry and open the file. <% Dim objFSO, objFile, objFolder Set objFSO...
  4. jon24422531

    Open a Web Page and pass login details

    Hi guys Not sure if this is possible in ASP, but here goes.... Our customers are able to access data on their transactions with us over a secure internet application. We grant them access through a user name and password that is stored in a SQL table. We used to add these users in an Outlook...
  5. jon24422531

    Split a recordset into columns

    Hi I am returning a recordset that has around 100 records. This should not vary by more than 20 either way. I want to create a check box for each record: Response.Write "<td><small><INPUT NAME=""EmailXtra"" TYPE=""CHECKBOX"" VALUE=" & rs.fields.item("Email").Value & ">" &...
  6. jon24422531

    Display Recordset in different order

    Hi guys I am running a query against our SQL database: SELECT DISTINCT(P.WorkLogNo) AS [Project ID], U.UserFullName AS Owner, (P.Urgency * P.Priority) AS [Rating], W.FaultType AS [Area], P.Title, CONVERT(char(20),W.AmendedStamp,0) as [Last Update], ISNULL(W.LastUser, 'N/A') AS LastUser from...
  7. jon24422531

    Passing several variables to an iFrame

    Hi guys I have a form on my page Invoices.asp which has several textboxes and select boxes etc. which the user fills out and then presses a button to go to another page. The SQL runs (it's a Stored proc) and all was well. However if I try to run the same but use an iFrame so that the user can...
  8. jon24422531

    Exclude a FieldItem from Recordset

    Hi guys I am trying to exclude a field from a table that is generated from a SQL recordset, however I wish to use the field items in the table as a "title". I have worked how to show (D) in the "title" bit, but I don't want the field (D) to appear in the table So I have a recordset with...
  9. jon24422531

    Changing an Email Link

    Hi guys Here is a very good reason to stop cutting and pasting code with out knowing how it works. Sadly I've never really understood JavaScript.... I have an internal website that Emails a User when their helpdesk question has been updated and there is a link...
  10. jon24422531

    Variable number of variables

    Hi I am currently trying to develop a little web app on our intranet where we are trying to limit use of SQL QA. So a user wants a query writing (say SELECT UserID, UserFullName, JobTitle FROM USERS WHERE JobTitle LIKE '%'+@JobTitleContains+'%' AND UserID LIKE @UserIDLike) This is stored in...
  11. jon24422531

    It's all about money!

    I have added another column to an existing table and defined it as MONEY. Default Value 0.00 Now when I either use QA to update the field in an existing record OR us EM and type directly into the column it stays at 0 update worklog..worklog Set EstimatedCost = '£12.00' where faultno = '303'...
  12. jon24422531

    EXEC a Stored Proc

    Hi Guys I am really struggling with this one and I suspect that I am going round in circles and missing something simple: On my page I run this Stored Proc: strsql = "EXEC JSp_DevLogFrameDetail '" & sCode & "'" rsData.Open strSQL, MyConn returns = rsData.GetRows(1,0) And the error I get...
  13. jon24422531

    Variable to an iFrame page

    Hi Guys I am trying to introduce a variable (sCode) into my iFrame page but I keep getting an error: Microsoft VBScript compilation error '800a0400' Expected statement /WishListDevelopment/DevTestOpen.asp, line 48 (sCode) ^ This works OK: <iframe id="datamain"...
  14. jon24422531

    Using a Table Variable in ASP

    Hi guys I am not sure why this doen't work, and can I use a @Table in an ASP Page? This works: strSQL3 = " SELECT UPPER(D.UserID)AS UserID, ISNULL(A.cnt, '0') AS [OPEN], ISNULL(B.cnt, '0') AS [ON-HOLD], ISNULL(c.cnt, '0') AS [DEVELOPMENT], D.cnt AS [Total] FROM" & _ " (SELECT DISTINCT(UserID)...
  15. jon24422531

    Browse for a File and pass the Link

    Hi guys I thought this may be easy, but I am not sure it is now.... I have an internal website at our company and we have a "HelpDesk" application where our users can type out their requests and it is all saved to a SQL Server as are our replies etc. It works well thanks to all the help I've...
  16. jon24422531

    Pass ASP request.Form to JavaScript

    Hi I am not sure whether this is in the correct forum, but I have an ASP page with various links on it and one of these I would like to open a "floating" page using information from a form. So far I have this: <SCRIPT LANGUAGE="JavaScript"> <!-- function showRemote() { self.name =...
  17. jon24422531

    Opening a link (with spaces) in word

    Hi I am trying to create a link that will open in Word, but I am already out of my depth.... I have a table that lists Customer ID's and a path to a word document: S:\Customer Documents\Customer Information Files\Gosport Loaders [G1] CIF.doc I then select that using a SQL statement: strSQL2...
  18. jon24422531

    Display a chart using a recordset

    Hi everyone This is not pretty, but I am trying to modify some borrowed code for our internal company website. (80% of the code is "borrowed") I can understand most of the workings, but I am not sure how to get it step through my recordset. I have tried several methods including getRows, but...
  19. jon24422531

    &quot;Real Time&quot; synchronous update

    We have an internal web application for fault reporting and all the info is stored in a SQL database, and with much help from Tek-Tips over the last 18 months, has been a great success. So a user looks up a fault report and it is displayed on a web page with a textarea for adding to the report...
  20. jon24422531

    Using a RecordSet twice

    Using ASP I make a SQL query to a database table and then return the recordset to a formatted table. set MyConn = Server.CreateObject("ADODB.Connection") MyConn.Open "Driver={SQL Server};Server=FTLive;Database=WorkLog;Uid=app;Pwd=;" Set rsData = Server.CreateObject("ADODB.Recordset") strSQL...

Part and Inventory Search

Back
Top