Search results for query: *

I am more than happy to try and change the setup of the tables that hold the info to speed things along. Any suggestions are welcome. I agree that above does seem over-complicated. - FateFirst

I personally didn't code this. It is part of a DotNetNuke asp.net module we hired someone to develop...however this developer let us down so I'm having to just takeover. I assume the reason match results are in 2 different rows is because either player can enter the score for BOTH sides. Having...

Soooo...to recap. A player submits the score for BOTH parties. An entry is made into nykGame (along with the UserID of the user who submitted the scores). The ID of the newly created nykGame record is taken and passed into nykScore.nykGameID along with the other relevant info to populate 2...

This is sorta a 2 part question although I am not sure if I should put them as one question...oh well ;) FIRST I am after a bit of help constructing a SQL query to return the correct results which are to populate a dropdown list from a StorProc. Its part of site for adding scores for squash...

There is more to it but I worked it out. The variable being assigned the value was orinally formatted as FormatNumber(,2) so I simply made it a Cdbl() and it worked fine. Sorry for not initially supplying the full info. - FateFirst

Im not great at maths anyways and I'm just looking to do a quick calculation on an ASP page. I'm guessing its producing an error because im not using a whole number as when I test with one it works fine. Error: Invalid procedure call or argument Any help would be appreciated. Here is what I...

Yea, im aware its not great to be completely in javascript. As I said in the first post: 'Ideally I would recode it to be an ASP generated...' This isnt my decision though and I'm just doing whats been requested. Thanks for all the info though. - FateFirst

heh dunno why I didnt think of such a simple solution (2nd para suggestion). ty! - FateFirst

I have a little form which is used for searching on on my ASP page. My question is regarding the <select>. It uses javascript to chuck the data into it. Quick Example: var country_select = document.searchForm.COUNTRIES_VALUE; country_select.options[0] = new Option("All")...

Heya guys/gals. Does anyone 'have/know where to find/got an idea' on how best to check if a server is up and running with a *basic* (sorry to use that word) ASP script. Maybe not the actual script but some ideas that I can go away with and code myself...my minds just a little blank. I dont...

Hi. I have a little script that streams files to users if they click on a link using the Server.CreateObject("ADODB.Stream"). Is it possible via this (or any other) to stream a file directly to the user and be able to specify the name of the file. Example: I have a folder off the root of a...

Thats perfect! Thanks Tsuji! I really appreciate your help on this. Take care! - FateFirst

Thanks tsuji! I actually had that earlier but used it in the wrong section which is why I wasnt receiving the correct data. That said, what would then be the best way to receive the sub-information: <property ref="1" status="Available" rent="0" sale="1" saletype="Off Plan" exclusive="1"...

Hi. I dont expect a solution as such but maybe just to be pointed to an area which contains enough information for me to get going. Most of the information I have read tends to be about writing XML and/or basic reading of XML files. Here is a sample of the XML data: <result> <header>...

Heya guys/gals! I simply want to display an image to users but let them have a little control over it. Control being: they can Zoom In/Out and rotate the image and drag it about as well. I have done a little research and can only find scripts that do the above but on an image manipulation...

The files exist within a sub-directory of the website. Root/download.asp Root/files/file.doc Its just a mini-document library. Users can log in and search various documents (searches information within a database that has been uploaded by the client). Then if the user has the permission...

Hey community! Just a quick question... I have done a quick script for a client for downloading files without passing path information through to the user etc using ADODB.Stream. Thats working fine... The client now also wants the user to be able to just open the file up in the browser (If...

Solved! Instead of using: DATEPART(""YEAR"",field_date) I used: DATEPART('YEAR',field_date) :D - FateFirst

Yea, forgot to mention I had done that already. Sorry ;) Works perfectly in Access. If I remove that part of the WHERE the statement works fine on my ASP page. This is why im slightly confused :) - FateFirst

Oops.... 'timesheet_start_datetime' should actually be 'field_date' but i forgot to change that. I was trying to rename some stuff quickly to make it more presentable :P - FateFirst