Search DaniWeb - sp2

Re: Design vs. Coding 2 Months Ago by cored0mp @Reverend Jim > That meant there were no junctions that could be disassembled to clean the insides of the pipes. They would have had to cut the pipes after installation and install access points to allow for cleaning. Design people often don't have maintenance as a priority. I agree and if anything I would go further. I don't see coding… Re: Problem Returning MySQL Stored Procedure results using Python 2 Months Ago by Dani Haha, good job! Thanks for sharing your solution. Sometimes that happens with me. As you type it up, you think about how to phrase what's wrong and what needs to happen, and it makes you think about it from different angles, and you figure it out. Re: Connect and call SP in MS SQL 2000 14 Years Ago by romanne SP: [CODE][COLOR="Red"]create procedure SP_getdata as set arithabort off declare @date1 datetime, @date2 datetime create table #tmptable ( data1 char(04) null, data2 char(03) null, data3 char(03) null, .. data35 char(50) null ) INSERT INTO #tmptable… How to fix the ASP .NET web pages. So that they will suit to the computer s 9 Years Ago by sweta87 SP .NET web pages. So that they will suit to the computer s Re: SUB the contents of two arrays and move the result in a third array 16 Years Ago by Tight_Coder_Ex SP is a special purpose register and it should never be used for anything other than what it was intended and you realize that anyway by your comment [B]this is wrong[/B]. You've got the right idea using index registgers, but you're failing to use instructions that give these registers thier potential, like LODS & STOS. [code=asm]loopi:… Re: parameter passing using stacks 13 Years Ago by gusano79 SP is just a pointer to somewhere in memory; nothing enforces stack discipline. If there's more code in the example than the one line you provided here, the rest of it might prove enlightening. Could you post anything else that came with the MOV instruction? Re: Securely Allow users to add to Database 18 Years Ago by Troy Sp!ke offers a nice solution to help prevent people from multiple posting. Thanks, Sp!ke! :) Jdmml, do you want to restrict public access to your form altogehter? If so, then you must password-protect the script or the entire directory. You can employ security at the web-server level, but how you do that depends on what web server you are using. … Re: DB Tables 18 Years Ago by Troy Sp!ke is correct. But of course you could always manually create your own table of table names. It would not be dynamic, but if you don't mind maintaining it for use in your admin app, it would work. Re: Google vs Kanoodle 18 Years Ago by Dani Sp!ke, you posted in the PPC forum which is for people who actually pay per click ;) However, it seems that you're trying to use an affiliate program such as AdSense (instead of the PPC program AdWords). Am I right? If so, let me know, so I can move your thread to the more appropriate forum. I think that's why c_shaft was confused - he was under … Re: Do you believe evolution? 15 Years Ago by MosaicFuneral SP clips, on YouTube, always get deleted. A more official link: [URL="http://www.southparkstudios.com/clips/155351"]http://www.southparkstudios.com/clips/155351[/URL] Re: Difference between XP Home and Pro Product Keys? 14 Years Ago by caperjack SP shouldn't matter as you are doing a fresh install! Re: Replace button with image 14 Years Ago by osirion666 Sp;ved i managed to overlay the button with a css image Re: I need some serious help, please! Delete isn't working! 11 Years Ago by HiWorld (sp)...totally fried... mssql_query() problem calling SQL Server Project (SP) 15 Years Ago by culebrin I have a SP (sp_test_procedure) created from a SQL Server Project in my SQL Server 2005 database, inside this SP I have a call to another SP which inside calls to a SP in another Database Server (SQL 2000) through a cross-linked connection. When I execute it from the Management Studio it works just fine. But when I call from my PHP app It gives … Problems with SQL SP 15 Years Ago by Ole Raptor I have a program that uses a Stored Procedure to create a report. Unfortunatly the SP has a problem in the VB6 code. The program could pull the information perfectly until 2 days ago. Now the program times out after 60 seconds after sending the params to the sp. I can run the sp in Management Studio and it takes approx. 3 seconds to pull 88 rows. … Re: Problems with SQL SP 15 Years Ago by Ole Raptor I had changed the sp a bit and got it to work in the program. It now takes about 10 seconds program side to run the report. This is the original problem. [code=sql] ALTER PROCEDURE [dbo].[MAR] @PatientID int = 0, @FacilityID int = 0, @IncludeVoid bit = 0, @IncludeDisc bit = 1 AS SET NOCOUNT ON --Remainder of SP [/code] The … IE hijacked-> res://sp.html#96676 19 Years Ago by Astial IE has been hijacked and I cannot seem to correct the problem on my own. I downloaded(and checked for current updates) the following programs: CW Shredder, Ad-Aware 6.0, HijackThis, Spy-bot S&D and after following the posts and running the programs I did fix alot of things that were bad, even corrected the DSO EXPLOIT problem with Spy-… Re: IE hijacked-> res://sp.html#96676 19 Years Ago by crunchie [list=1][*]Make sure your settings allow you to view "Hidden files". Open up any explorer windows and click on "Tools" => "Folder Options" => "View" and be sure to check off "Show Hidden Files and Folders". Uncheck the Hide protected operating system files option. [*]Press Ctrl+Alt+Delete … Re: Problems with SQL SP 15 Years Ago by Ramy Mahrous If it's not confidential, you can show us the SP to see if we can optimize it. I think in connection string you can specify the time out value play with it, it may solve the problem on the first machine. exec sp from another SP 4 Years Ago by Menzk I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset PHP+ SQL server 2005 SP problem 15 Years Ago by odysseous Hi everybody, I have a ntext problem. There are MS SQL SP in my project.And I am taking mssql_bind() warning and mssql_execute() error. But the problem is that I cannot make changes on these SPs. Because these Sp are used by other programmers who are using cold fussion as programming language. Thus I could not use cast trick. What can I do? Has … Cann't see hidden files and folders in Windows XP, SP-2 15 Years Ago by java_programmer I have Windows XP, sp-2 installed in my laptop. I have stored personal file as hidden file and set the properties 'do not show hidden files and folders' on as anyone else can't see the files. But when I tried to disable this feature and enable the feature 'show hidden files and folders' and click the apply button, it is not working. The hidden … Connect and call SP in MS SQL 2000 14 Years Ago by romanne Hi, Im new in C#, could you help with my codes. I need to connect to MS SQL DB (2000) and need to call Stored Proc to return value. Here is my codes: [CODE][COLOR="Green"]private void ExecuteStoredProcs() { SqlConnection conn = new SqlConnection(connectionString); try { conn.Open(); SqlCommand getRequestCmd = new … incorporate the UDF functionality into the Sp 14 Years Ago by vuyiswamb Good Day All I have an Sp and UDF. the UDF cant take #tables. so i want to incorporate the functionality that is being provided by the udf and make it part of the code. the first part of my statement creates a solid table that is being used in the UDF [code] truncate table temp INSERT INTO temp SELECT MTN.ID,S.DESCR,ISNULL(MTN.CYCLETEMPLATE,C.… Re: Cann't see hidden files and folders in Windows XP, SP-2 14 Years Ago by sanjitsrivastav [QUOTE=java_programmer;821285]I have Windows XP, sp-2 installed in my laptop. I have stored personal file as hidden file and set the properties 'do not show hidden files and folders' on as anyone else can't see the files. But when I tried to disable this feature and enable the feature 'show hidden files and folders' and click the apply button, it … Re: Cann't see hidden files and folders in Windows XP, SP-2 14 Years Ago by karthickj25 [QUOTE=java_programmer;821285]I have Windows XP, sp-2 installed in my laptop. I have stored personal file as hidden file and set the properties 'do not show hidden files and folders' on as anyone else can't see the files. But when I tried to disable this feature and enable the feature 'show hidden files and folders' and click the apply button, it … Check if record exists using SP & return value if it does 11 Years Ago by while(!success) Hi guys, I'm still new to .NET and your answers to my questions have been so helpful. I have another question yet again, however. This time my question has to do with sql server and handling it with code behind. I am creating a stored procedure which is supposed to check if a record exists in the table and if it does, return a value so that I may … Re: Connect and call SP in MS SQL 2000 14 Years Ago by sknake What does your SP do? Does it return a cursor (does it have a Select query inside of it?) or are you just trying to get the integral return value of the sproc? Re: Connect and call SP in MS SQL 2000 14 Years Ago by romanne Hi Sknake, Theres an insert into in the SP that i need to call. Re: Connect and call SP in MS SQL 2000 14 Years Ago by romanne I also need the data that i get in my SP and i declare the per data in an array... like this one: data_1 = array[1 - 1]; data_2 = array[2 - 1]; and so on....