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 Chriss Miller 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: *

  • Users: lifesupport
  • Order by date
  1. lifesupport

    Session State vs Dynamic Queries

    I suppose I don't have to return it to a table. I was trying to do so in order to save selections made by the user. I could save the selections to an array and/or cookies. Your link looks interesting. Thanks
  2. lifesupport

    Session State vs Dynamic Queries

    I'm writing a web app (and learning at the same time) that will have daily usage by approx 100 or less users. This app will have a large variety of select statements all based on the users' selections. I want to make sure that the user's selections will not get mixed up with each other as I've...
  3. lifesupport

    dyname paramaterized select statement

    I like the Print @SQL idea. Thanks
  4. lifesupport

    dyname paramaterized select statement

    Never mind. I got it going. I'm new to SQL and I didn't realize SQL is sensative to spacing. It didn't like the 'dbo.' either. The following works: select @SQL = 'select statecode, statename, statenum, nstatenum, selection ' select @SQL = @SQL + 'into ' + @tablename select @SQL = @SQL + ' from...
  5. lifesupport

    dyname paramaterized select statement

    I get the following error when I run the stored procedure below. I can't see what is wrong. It's a simple select statement into a paramaterized table. Thanks When running, it asks me to feed in a variable so I type Selstate123 Error Msg: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near...
  6. lifesupport

    Newbie LINQ question

    I'm trying to learn LINQ, but it seems that regardless of what tutorial I find, nothing works. It doesn't seem to be making the back of the scenes classes. I keep getting a filenameDataContext not declared error and I have no .cs files as the northwind sample has. Anyone know what I may be doing...
  7. lifesupport

    Error in installation?

    I'm trying to use the wizard to set up a SqlDataSource connection. It works fine except I can't get it to update. When I get to the "Configure the Select Statement" screen and click on the "Advance" button, all check boxes are disabled for the "Advanced SQL Generation Options" screen. Can anyone...
  8. lifesupport

    Newbie Question

    I'm trying to visually connect a database to a grid. While configuring the select statement in the 'Configure Data Source', I select the 'Advance' button. The 'Generate INSERT, UPDATE, and DELETE statements and the 'Use optimistic concurrency' options are not enabled; therefore, I can't select...
  9. lifesupport

    newbie question about views

    Thank you all for your patience. I suspect I don't know enough yet in order to ask the question properly. What I'm trying to do is exactly what tsuji said in his #1 option: [1] If the static views (or even tables or columns) have names actually not beginning with @ (normal case), and that you...
  10. lifesupport

    newbie question about views

    If I want the name of the view to actually be a variable, then I need to use the '@' symbol unless there is another way to do this. Since this results of this view will be used for the duration of the application, I don't want users overwriting each other's views so I want a dynamic view name...
  11. lifesupport

    newbie question about views

    I'd like to know if this is possible and if so how do I write the code? I created a view in SQL and named it @view_selstate because I wanted the name to be a variable. I'm not sure if I can do this, but it took in SQL. I then was trying to reference it in Visual Studio VB Script i.e. if...
  12. lifesupport

    SQL 2008 Install Problem?

    I installed SQL 2008 - everything except analysis and reporting. Whether I create a table or if I import tables, the database will not open and stays frozen in debugging mode when I try writing code (a simple 'use databasename') on the table. Below is my install summary. Is it because I...
  13. lifesupport

    SQL 2008 Install Problem?

    I installed SQL 2008 - everything except analysis and reporting. Whether I create a table or if I import tables, the database will not open and stays frozen in debugging mode when I try writing code (a simple 'use databasename') on the table. Below is my install summary. Is it because I...
  14. lifesupport

    Different results

    We have a marketing app that crunches data thru several select statements and a few computations and outputs a report. The app is producing different results on different machines. What would be the cause for this? We make sure we had the same exact data and the same exact executable, yet...
  15. lifesupport

    DTS install

    Hello, I've installed the Developer version of SQL 2005 on Windows 2000. All went well, but some features seem to be missing such as the DTS option, which seems to be quite valuable. For now I downloaded the SQL 2000 and works as a separate application, but not all the file types work on...
  16. lifesupport

    Web design with Access front end and SQL back end

    I'm transferring a desktop application to a web application. This application utilizes a lot of foxpro SQL statements, so converting this to SQL probably won't be a problem. The desktop application is written in VFP so it's not designed to be multi-user. Since user's will be making selections...
  17. lifesupport

    Recommend a book

    The book "MegaFox: 1002 Things You Wanted to Know About Extending Visual FoxPro" claims to cover PDF; however, I am only interested in concatenating Ghostscript. Straight forward printing in both Adobe and Ghostscript and concatenating in Adobe are all easy and I don't need a book for these. I...
  18. lifesupport

    Ghostscript - Concatenate

    Has anyone gotten Ghostscript to concatenate within VFP? If so, what was the line of code within ps2pdf used? (i.e. m_cmd = [ -q -dSAFER -dNOPAUSE -dBATCH -sDEVICE#pdfwrite -sOutputFile#]+m_outfile +[ -dnodisplay -dCompatibilityLevel#1.2 -c .setpdfwrite -f ] +m_ifilename) Is there another way...
  19. lifesupport

    Concatenate Ghostscript PDF reports

    I'd like to use the new VFP 9.0 concatenate features to concatenate Ghostscript reports. I got these working with Adobe, (Report FORM (lcReport) NEXT (mtopcnt) NOCONSOLE TO PRINTER NOPAGEEJECT) but I'm not able to get it to work with Ghostscript. Does anyone know how to concatenate Ghostscript...
  20. lifesupport

    Concatenate PDF Reports

    Thanks for your response Mike. I mis-spoke above. It initially creates a post script file not a PDF. That is why the file has a 'nopageeject' so that I can continue to add reports before I close the file and convert it to a PDF. Report #1 doesn't work. The lcreport is simply the report name...

Part and Inventory Search

Back
Top