Recent content by murphyhg

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...