Wrox Programmer Forums
|
ASP.NET 1.0 and 1.1 Professional For advanced ASP.NET 1.x coders. Beginning-level questions will be redirected to other forums. NOT for "classic" ASP 3 or the newer ASP.NET 2.0 and 3.5
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 8th, 2007, 01:04 AM
Registered User
 
Join Date: Aug 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default invalid object dbo.split error............

Hi i'm using a stored procedure ..
Which contain the function dbo.split(....)
When i try to use this stored procedure in the local it works fine.
when i try to use that stored procedure i get the error invalid object dbo.split
can some one please help
Thank you

 
Old August 8th, 2007, 06:31 PM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

I assume you are using one of the split() function sql scripts that is readily available on the net and that it returns a TABLE data type as opposed to a varchar or int.

You can only call a function like this:
SELECT split('My String', ' ')

when the function returns a scalar value (just one value such as a varchar or int value) but when the function returns a result set such as a TABLE you have to do something like this:

SELECT * from split('My String', ' ')

This will return you all of your results.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========





Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot insert duplicate key row in object 'dbo.mov alxGramma SQL Server 2005 4 April 15th, 2008 01:42 PM
valid dbo; permission to impersonate dbo est BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5 5 February 21st, 2007 04:44 AM
"Invalid object format name" Error welles Crystal Reports 2 September 27th, 2006 04:42 AM
Invalid Object Name busybee ASP.NET 1.0 and 1.1 Professional 1 July 5th, 2006 11:13 PM
Invalid object name Syed Naveed Khursheed BOOK: Beginning ASP 3.0 8 November 20th, 2004 01:42 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.