Recent content by NevG

Can anyone please help me. I have NPF 2001 installed on my machine and for some reasn I cannot download files etc... The net works fine through my broadband ISP but download ing is not happening at all ... what do I need to set / check / create rule for .. to get this to happen..?? any help...

Hi gang Cant code my way out of a paper bag today .... Can someone tell me how to query an aliased column? select col as new_colname from table where new_colname = [value] thanks guys and gals.. duh !!

that would be fine if it was always going to be a integer .... however the field is a varchar for a reason - it will contain both alpha numeric in it which is y I think this is impossible! any other thoughts

1 11 11test 1test 2

HELP!! Can someone please tell me if its possible to sort numeric fields in a varhcar column according to their number?? ie values I have are test1, 1,11,2,0 and it orders them as 0,1,11,2,test1 I really need it to order as: 0,1,2,11,test1 ... is this possible without ripping out SQL...

Gang urgent help needed here please I am trying to use an activex control on my ASP page using the following element... <OBJECT ID="xxxxxxx" CLASSID="CLSID:0C7E16D7-3A53-43EB-83C6-392F348A5E72" CODEBASE="Name.CAB#version=1,0,0,0" VIEWASTEXT> </OBJECT> But for some reason the control wont...

hi gang I have 3 tables spread over 2 sql instances and I need to query both of them... I know I can do this by fully qualifying the server name etc. in the query syntax... HOWEVER - I do not know what the name of the server is going to be. I also know that I can check the sysservers table...

Hi gang can someone please tell me why I am not able to set the innerHTML of my dropdown select control using javascript Im trying to change the contents of my second slect control from the choice in the first one using an XML string that has come back from end. When I format the xml into...

Hi I have recently rebuilt my machine which had 2 partitions on it now only got one large one... When system boots I still get operating sytem choice screen displaying both O/S options... I only have one.... How can I get rid of this annoying screen? I checked my boot.ini and removed the...

Hi gang Having serious mind meltdown ... I am calling an SP that has aFOR XML Clause in it How can I say strVar = adoCommand.execute to get the XML string back as a result set.. total meltdown here Thanks NG

Hi troops I have a sql procedure that queries the system tables, inserts column info into a temp table and then selects * fro xml auto from that temp table - temp table is then cleared up I have a function to query system tables to work out what parents a table has according to tableID - this...

Hi gang PLease- please help me with this I have a DTS package that calls a sp that requires params. It so far looks like so: spParamName ?,?,?,? I have set up the params as defaults etc... however when I try to run the package it fails giving me the &quot;No value set for one or more...

Hi troops Im trying to add a kind of abstraction layer to SQL Server by adding my own SP's that accept a table name and spits out a ball of XML containing columns from that table including useful attributes.. I have gotten this far - however it will be really useful if I could find out...

Hi gang Can someone tell me how I can change the code below to work using an IP address.. I cant fdind anything anywhere to help me so Im hoping you guys can.. MessageQueue MSMQueue = new MessageQueue(ConfigurationSettings.AppSettings[&quot;QueueAddress&quot;]) Help me PLEEEEEASE!!! Cheers...

Hi gang I have a form on my web site that I want to mail teh contents to a specified address WITHOUT th user having to endure Outlook or other mail program opening... I basically want this to submit give them a msg saying THanks and its all been mailed to my address I cant use CDONTS bcos of...