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!

  • Congratulations Wanet Telecoms Ltd 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

    ...results. What's the best route for this concern? Code will execute but will not display. this is not good because I can't call it with Select * from @tablename @tablename varchar(50) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT...
  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

    ...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 '.'. ******************** Stored Procedure Code: ALTER PROCEDURE [dbo].[SP_MakeSelStateParam] @tablename varchar(50) AS BEGIN from SET NOCOUNT ON...
  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?

    ...Install ADDCURRENTUSERASSQLADMIN: False AGTSVCACCOUNT: NT AUTHORITY\SYSTEM AGTSVCPASSWORD: ***** AGTSVCSTARTUPTYPE: Manual ASBACKUPDIR: Backup ASCOLLATION: Latin1_General_CI_AS ASCONFIGDIR...
  13. lifesupport

    SQL 2008 Install Problem?

    ...Install ADDCURRENTUSERASSQLADMIN: False AGTSVCACCOUNT: NT AUTHORITY\SYSTEM AGTSVCPASSWORD: ***** AGTSVCSTARTUPTYPE: Manual ASBACKUPDIR: Backup ASCOLLATION: Latin1_General_CI_AS ASCONFIGDIR...
  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