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 TouchToneTommy 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: *

  1. murphyhg

    Grant user role to only select view and nothing else

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

    Error in code with cursor

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

    Cold fusion graph excel

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

    ColdFusion Cloud Hosting

    Try Hostek, they are pretty good.
  5. murphyhg

    Page Scraping

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

    extract filename and update DB

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

    extract filename and update DB

    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!
  8. murphyhg

    Remove all characters after SF

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

    Remove all characters after SF

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

    Remove all characters after SF

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

    function getting error in IF Statement

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

    function getting error in IF Statement

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

    function getting error in IF Statement

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

    cfgrid row select

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

    cfajax tabs &amp; cfajax grid ColdFusion 8

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

    Creating a Foreign Key

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

    Creating a Foreign Key

    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`)...
  18. murphyhg

    Snapshot Replication cannot bulk copy into table GETITEMS.

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

    How to use COALESCE with FullText Search

    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)...
  20. murphyhg

    How to use COALESCE with FullText Search

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

Part and Inventory Search

Back
Top