Search results for query: *

Phil Genius! When you explain it like that the answer is so simple... Many thanks Jonathan Jonathan www.jonschofield.com

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

Phil (Vacunita) Schoolboy error... I am a buffoon and failed to check my query properly. Your code works perfectly, many thanks. Have another star When I feel ready to attempt allowing readers to add comments then I shall be back here I'm sure. Jonathan www.jonschofield.com

Phil I tried your suggestion, but I can't seem to get it to work and I am sure I am missing something... The page loads but there is no data returned from mySQL, I have discovered with PHP that if there are any errors then the page is blank, and here that is not the case, so I think I may have...

Phil / Olaf Thank you very much for your input, when I get chance (in between working for a living) I shall have a shot at trying your suggestions. Incidentally, the reason my query parameter is for BLIndex > 13 is that entries prior to that were just tests that I haven't deleted yet. After...

Phil Thankyou for your help, but as I said, this is new to me and I got lost at the GET superglobal...... As I see it, when a visitor clicks on the blog link then I load every entry in the table: <div id="Blog"> <span class="shadow">The Blog - Musings &amp; Mutterings by a Malcontent</span><p...

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

Hi Foxbox Apologies for the late response, this particular project has been overtaken by another until now. So, I can get the search to work on the local server, but to list files on the domain I need to use IUSR_computername and allow this access to the server with the files on it. However...

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

Foxbox That may do it.... I'll have to do this later due to other commitments but thanks for all your help. I'll let you know if it worked. Jonathan www.telecom-stuff.com

Now I see the problem Foxbox. The web address I'm trying to get to is in a DMZ on the other side of our network (as it is for external customer access to information on our SQL server) That is why it won't work , but is also why the VBA sendKeys can. Not sure what to try next.... Jonathan...

Foxbox I can't seem to make it work, but I have to log off now. I'll have another look in the morning... Thanks for your help and I'll let you know as soon as I've had another try. Jonathan www.telecom-stuff.com

Ah, Foxbox an elegant solution but.. (there's always a but) Login.asp is part of our customers Internet application that was written by a 3rd party over which we have little control. In the VBA version we were simply opening the website and then passing keystrokes (with suitable pauses) and I...

Hi Foxbox That's exactly what I want. One of our team can either create or modify a user and then at the press of a button open a new web page with their details entered. Can we do it? Jonathan www.telecom-stuff.com

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

Guys Thanks for your responses, and apologies for not replying sooner (Just had a weekend without any screens!). After I had posted the question I found a suitable answer on Google and both of you were in the right ball park: I post my solution here for others to see and use. <% nCount = 0...

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

George Thanks. I always assumed that you could only use DISTINCT with the first column in the SELECT statement and always used parenthesis. I did a small experiment where I made two other records identical apart from one field and tried the query again, it worked. Thanks again Jonathan...

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