Search results for query: *

I have 2 databases. Let's call them dba and dbb. I have a user in dba called dba_users that needs select and select only for a view in dbb. It is called dbb_view. I am thinking that the best way is to grant a role for that user. dba_user_role. What is the syntact for creating the user and...

When I try and package this stored procedure I get an error. Error report: ORA-06550: line 2, column 1: PLS-00905: object moveproduct is invalid ORA-06550: line 2, column 1: PL/SQL: Statement ignored 06550. 00000 - "line %s, column %s:\n%s" *Cause: Usually a PL/SQL compilation error...

Have you looked at cfspreadsheet in ColdFusion 9? http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec17cba-7f87.html

Try Hostek, they are pretty good.

I need to create a new layout dynamically using ColdFusion by scapping the top and bottom of the page and saving as 2 different variables. The top stops at the top until this. <!--googleoff: all--> (This is in an HTML Comment) The bottom starts after this <!--googleon: all--> (This is in...

SQLBILL, to be honest that is totally over my head. If you can help it would be most appreciated.

I have inherited a db which has this for a file name. <img src="images/thumbs/thumbwestplaza.jpg" alt"West Plaza"> How can I extract thumbwestplaza.jpg and update the database with that. I would do it by hand but there are too many records. Thanks for your help always!

I modified the query to read SELECT Left(STORE_SIZE,InStr(1,STORE_SIZE,"SF") +1) AS R_STORE_SIZE FROM TENANT_TBL WHERE DISPLAY = 1 The error that is returned to me is [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

Thanks I tried that and I am getting this Too few parameters. Expected 2. Here is my code SELECT Left(TENANT_TBL.STORE_SIZE,InStr(1,TENANT_TBL.STORE_SIZE,"SF") +1) FROM TENANT_TBL WHERE TENANT_TBL.DISPLAY = 1 AND TENANT_TBL.IMAGE_FILE = 'image' ORDER BY...

I am doing an Access 2003 query and I need to remove all characters after SF. SF appears like this 2,000 - 10,000 SF, I cannot use a counting method to determine the position because SF could appear like this also. 1,000 - 2,000 SF Thanks for your help.

@gmmastros, thanks for your quick reply this is working.

I cannot seem to get the syntax correct for this. Getting these errors. Msg 156, Level 15, State 1, Procedure getContentURLSetByPass, Line 18 Incorrect syntax near the keyword 'AS'. Msg 156, Level 15, State 1, Procedure getContentURLSetByPass, Line 30 Incorrect syntax near the keyword 'IF'. Msg...

Hello, I am trying to modify this function to pass an additional parameter to it called ByPassURL. If the variable ByPassURL is empty I would like to do one thing. If it is not empty I want to insert BypassURL into the table and return it. This is the error I am getting. Msg 156, Level 15, State...

John, take a look at this and see if it helps. http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec22c24-7acf.html#WSc3ff6d0ea77859461172e0811cbec0fb54-7fcf

I am using cfajax tabs and cfajax grid html. Is there anyway when I visit this page (http://www.renaudconsulting.net/properties.cfm) in IE8 & Firefox 3.6 that the grid can be expanded out to include all rows. When I refresh the page it is all there. I have tried to see what css is controlling...

Don, thanks for your quick reply. You were correct. I had some data in the propertyid column in the anchors table which did not match the id of the properties table. Once I set the 0 zeros to NULL the issue went away.

I have been struggling with how to create a Foreign key on these 2 tables (anchors, properties). The tables already exist and have data in them. This is my script to create the Foreign Key and below is the error. ALTER TABLE `anchors` ADD CONSTRAINT `PROPERTYID_FK` FOREIGN KEY (`PROPERTYID`)...

Hi Thanks for your help. I am trying to setup snapshot replication between 2 different SQL2K5 databases. I keep getting this error and I am not sure how to turn on verbose logging? I also saw that this might help but not sure how to use it. UseInProcLoader

Thanks for your help always. How can I run this stored prodedure and not get this error? Null or empty full-text predicate. If I feed all 4 parameters it works. create procedure dbo.usp_AdvancedSearchArticles @content nvarchar(255) = NULL, @title nvarchar(255) = NULL, @summary nvarchar(255)...

I am trying to create an advanced search passing in parameters that I want to be able to use COALESCE with FullText Search on those parameters. I do realize that if they are set to null I will get an error. What is the proper COALESCE syntax to get this to work with FullTextSearch? create...