You searched for the word(s): userid:685089

More Search Options

RSS Available

• Re: Error: The string was not recognized as a valid DateTime. There is a unknown word starting at index 20.

  Unfortunately, this did not do it. I really do not understand this problem.

  Posted to .Text (Blogs) (Forum) by ounlopez on 11/16/2007

• Re: Syntax error in accessing an object (table value function)

  Ah, thanks. What this was is in the conversion to Server 2005, from Server 2000, the object's name was made more explicit. It included our database name and the login name for the database. Adding that to our script worked like a charm. Thanks Again! -Steve dbo.user.person_info

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ounlopez on 8/29/2007

• Re: Syntax error in accessing an object (table value function)

  Thanks Mystery, I made these changes, but still get an object error.....any further ideas? Maybe the error is in the person_info function? "INNER JOIN (SELECT * FROM Person_Info(" & Session("current_project") & ")) pe ON pc.personID_fk=pe.personID_pk " & _

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ounlopez on 8/29/2007

• Syntax error in accessing an object (table value function)

  I am trying to access data from a database to print a report. The code I am using says I have a syntax error regarding the object person_info. Person_Info is a table value function on the SQL Server (2005). Does anybody see a problem with this line of code? Thanks for your help! Regards, Steve "INNER JOIN (SELECT * Person_Info FROM (" & Session("current_project") & ")) ON pc.personID_fk=pe.personID_pk " & _

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ounlopez on 8/29/2007

• Re: printing reports problem

  Okay, I have been able to narrow down my problem (after some head scratching). Now, I am getting this error: Incorrect syntax near 'Person_Info'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near 'Person_Info'. Here is the offending code: System.Web.HttpContext

  Posted to Web Forms (Forum) by ounlopez on 8/28/2007

• Re: printing reports problem

  Hi NetProfit,

  Posted to Web Forms (Forum) by ounlopez on 8/28/2007

• printing reports problem

  Hi all, I have recently reinstalled a database that allows me to make reports. We were able to print these on a previous system, but now I keep getting the message "There is no data for this cycle" when I click on the print icon. This message was programmed to come on when no data exists. But now, its always there. Unfortunately, there is almost one thousand lines of code. I am posting it below for any advice! Thanks in advance!

  Posted to Web Forms (Forum) by ounlopez on 8/27/2007

• Re: SELECT permission denied on object 'aspstatetempapplications'

  Hmmm, I actually already have the ASPstate database on the server. Any other ideas? -Steve

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ounlopez on 3/28/2007

• SELECT permission denied on object 'aspstatetempapplications'

  Hi all, I know this error (below) has been presented before, but I have tried the typical solutions without any luck. The solutions I have tried involve insuring cross-database ownership is enabled. We have run the following query, without any luck with fixing the error. Is it possible we have something wrong with the tempdb, or modeldb? All the settings appear to be normal (dbo public access). Any ideas would be appreciative. Thanks, Oun To reconfigure SQL 2000 SP3 for ASP.net session state you

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ounlopez on 3/28/2007

• Re: Error: The string was not recognized as a valid DateTime. There is a unknown word starting at index 20.

  Was this problem ever solved? I am having a similar problem, and not sure where in my script it is ocurring. Any ideas? Thanks, Oun

  Posted to .Text (Blogs) (Forum) by ounlopez on 3/8/2007