Search results for query: *

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...

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...

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...

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...

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 & ">" &...

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...

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...

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...

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...

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...

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'...

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...

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"...

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)...

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...

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 =...

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...

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...

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...

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...