Search results for query: *

Hi Jason, Thanks for responding. I agree with you, and in the long-term, I'll make the switch to C#, and rebuild the vb.net pages. I've made some progress since my post. I removed the vb.net project from the solution, rearranged the folders (solution/project_2/project_1), then re-added the...

Hi All, My project_1 folder contains all the asp.net/vb.net pages for my website. I created a project_2 folder for a new c# login page. I did this because I needed to add OpenID support (dotNetOpenAuth), couldn't find any vb.net samples, and wasn't up to the task of porting the c# code to...

Hi Markros, retyping the statement did the trick. I guess something got corrupted when I moved the solution from my winXP setup? Thanks again for the quick response, Mark

Hi Everyone, My program is failing so I stepped through my asp/vb.net method and copy/paste/parsed the content below from my string variable into the query window; update data set affiliated_unit = account_code  where company = 'US - Charleston Place Hotel' and account_code in (select...

ok, figured it out. The first time page_2 loads, I use the session variable to filter, then clear them out. Subsequent page loads (due to data updates on the page) don't reload the original data, since the page_load event tests for the session variable before filtering. Thanks tek-tips!

ok, so I'm using session variables now, since I need to make multiple edits on page_2. page_1's url button click event looks like session("id") = 123. page_2 loads and filters appropriately. Then I empty the session variable, so form edit/updates (which trigger page_load) don't have a session...

it looks like the page load is firing each time I try to update data on page_2, or try to use listbox_2. Sort of like an infinite loop. So I guess my question is really, how do I pass the variable without appending it to the URL, since I need to stay on page 2 and edit data repeatedly.

Hi, My page_1 allows you to look up data with listbox_1. I needed to pass listbox_1.SelectedValue to page_2 so I added an id variable to the page_2 url like page_2.aspx?id = 123.Page_2 loads, sees the variable, sets listbox_2.SelectedValue to the right value, and refreshes the textbox. But...

Hi, I logged in as SA, and created a login and user. I then granted the user rights to execute some stored procedures. This was all done using the dialog boxes. When I returned to the dialog, the execute checkboxes were unchecked. I then wrote a script to do the same thing. The script ran...

Thanks Steve, much appreciated. Mark

Just found this link... might be promising. http://rubyonwindows.blogspot.com/2007/03/ruby-ado-and-sqlserver.html http://rubyonwindows.blogspot.com/2007/03/ruby-ado-and-sqlserver.html

Just some random questions... working on my first RoR/SQL Server 2000 app. Do I need to have the database running locally during development? How do I confirm my rails app is connecting to my remote server? How do I handle migrations to a remote server? I need to display relational data in...

Here's what I came up with; SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[z_detective]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[z_detective] GO CREATE PROCEDURE dbo.z_detective @string...

Thanks SQLDenis, The paper was a big help. I'm working my way through the required changes now. ESquared, The procedure isn't for production use. I need to figure out the table structure of a very large legacy application so I can add reporting features. The idea is to have users enter test...

Hi, I need to build a list of table and column names using sysObjects and sysColumns, based on the contents of a column. This procedure attempts to loop through each user table's varchar column(s), storing matching values in another table. My problem is I can't figure out how to use...

Just wanted to chime in. I was looking over my own problem with the 8000 limit, and found that select @sql didn't return the full string, but print @sql did (thanks again George). Not sure why. Also, I handled the 8000 max varchar and exec() character limit with nested if statements in my...

Thanks George. I appreciate the help.

Hi, This piece of my SQL Server 2000 stored procedure compiles, but gives me this error when I run it? The name 'CREATE TABLE #pivot (property CHAR(5), metric CHAR(25), field1 (INT) NOT NULL, field2 (INT) NOT NULL, field3 (INT) NOT NULL, field4 (INT) NOT NULL, field5 (INT) NOT NULL, field6...

Hi: I'm studying Java in school and need some help. I mention that I'm studying it because I need to write the code myself, and so I guess I'm looking for an explanation more than anything else. My project is to build a stack using an array. If the stack is popped and is empty, then the app...

Thanks for the help uncleirco, still no luck.