Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. markgrizzle

    How to call project 2 aspx from project 1 aspx code-behind

    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...
  2. markgrizzle

    How to call project 2 aspx from project 1 aspx code-behind

    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...
  3. markgrizzle

    tsql update... fails in code, but works in SSMS editor?

    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
  4. markgrizzle

    tsql update... fails in code, but works in SSMS editor?

    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...
  5. markgrizzle

    Passing variables between pages...

    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!
  6. markgrizzle

    Passing variables between pages...

    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...
  7. markgrizzle

    Passing variables between pages...

    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.
  8. markgrizzle

    Passing variables between pages...

    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...
  9. markgrizzle

    Assigned Permissions Not Saved in SQL Server 2000

    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...
  10. markgrizzle

    Using SQL Server 2000 with RoR

    Thanks Steve, much appreciated. Mark
  11. markgrizzle

    Using SQL Server 2000 with RoR

    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
  12. markgrizzle

    Using SQL Server 2000 with RoR

    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...
  13. markgrizzle

    How do I use variables for tbl & col names in select stmnt

    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...
  14. markgrizzle

    How do I use variables for tbl & col names in select stmnt

    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...
  15. markgrizzle

    How do I use variables for tbl & col names in select stmnt

    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...
  16. markgrizzle

    rows as columns matrix query or view

    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...
  17. markgrizzle

    Stored Procedure Loop Code Fails

    Thanks George. I appreciate the help.
  18. markgrizzle

    Stored Procedure Loop Code Fails

    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...
  19. markgrizzle

    throw IllegalElementException

    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...
  20. markgrizzle

    Sending an email from within ActiveX script

    Thanks for the help uncleirco, still no luck.

Part and Inventory Search

Back
Top