Search results for query: *

Thanks jpadie I will check out tool-man.org Shaun

I am writing a CMS system I have been puzzling over this for a few days and not getting anywhere. I have a table which has a column content_order this holds an integer which dictates the order of paticular content articles. I have an interface which lists the articles I want to add...

Thanks for the advice Rob I haven't changed the owners but get a Sa login error when I try to run one storedproc so guess i have a permissions issue somewhere. Can i reset permissions once replicated I am new to replication?

I have a database which is to be replicated, I connect to this db from ASP using integrated security (therefore have IUSR_etc for each machine as logins) Currently the dbowner is sa is this my best approach as this user should be on all replicated machines? Thanks for any advice SDH

Yes If i append return @tbOrd_id to my sp I get a value on the replication master However on the replicated databases running the same procedure I get NULL

on a replicated db this has started to return NULL for scope_identity any ideas why? INSERT INTO "dbtophorse"."dbo"."tbOrder"("tbOrd_total","tbOrd_datetime","tbUsr_id","tbshipingID") VALUES(@orderTotal,GETDATE() ,@User,@tbshippingId) SET @tbOrd_id=Scope_Identity() Thanks SDH

I think there maybe better ways of doing what you want to achive but to adapt your code just see below <% ' ///////////////////////////////////// ' login validation script ' © Matt Millross ' www.designplace.org ' free for use as long as copyright notice left intact ' For more scripts, visit...

Ok jimbo So if I set static IPs can they all be in the same range?

Thanks bcaster I did not really want to buy another piece of hardware is this the only solution

I have two broadband connection now on our network 1 adsl line and one sattelite i have two routers 'wireless adsl router' and satelittle router How can i set the network up to use either or both of the gateways satellite is currently 192.168.0.130 (network range 192.168.0.1 to...

For completeness I realised the problem came when looping through the collection. I failed to assign the key to my condition statement.

Thanks Fester & sheco I am building the list dynamically must be some syntax error or something on my check if selected routine I will look into it further

doesn't seem to I am stuck!!

I am looking to post a page back to itself for confirmation and cannot find how to maintain the state of a select box which has multiselect set can anybody help PLEASE

if sure DSN is set up correct then what is the value of strconnect if you do a response write on it try putting at line 39 RESPONSE.WRITE STRCONNECT RESPONSE.END to ensure you have corretcly configured DSN string

Thanks Each recordset consists of two fields (returned from the exec statement) but when I follow vongrunt's method I get 1 record three fields all 0 can anyone explain

Please help I want to concatenate the results from three recordsets returned from one procedure the procedure is simply ALTER PROCEDURE [dbo].[usp_keywordSearch] ( @keywords varchar(2000) ) AS Begin DECLARE @CRC int -- Set parameter values EXEC @CRC =...

Thanks so much I will give it a try

Please help I have xml documents structured as below and want to transform them so it it only consists of records where there are no duplicate tbHrse_id value nodes <?xml version="1.0" ?> - <horses> - <horse> - <field name="tbHrse_Name"> <value>NO COMPLAINTS</value> </field> - <field...

OK Why not input box max lenght 6 Validate using instr() to ensure that character 3=: then evaulate left(2) <24 evaluate right(2) <60 or is this to simple?