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

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

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

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

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

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

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

When I try and do a full text search term with spaces like this exec usp_PrimarySearch 'Tech terms' I get this error Msg 7630, Level 15, State 3, Procedure usp_PrimarySearch, Line 16 Syntax error near 'terms' in the full-text search condition 'Tech terms'. How can I fix this? ALTER PROCEDURE...

I am creating a versioning scheme using a trigger and I do not want to insert a new row into the audit table unless the article is live. I have a column called live which is a bit field. So, if LIVE is true I want the row inserted. I tried putting an if statement around the Insert statement but...

Any thoughts on how I can clean this up a little and not have duplicate rows? SELECT DISTINCT Articles.Title AS Title, Articles.ByPassURL, Articles.LocName AS ParentName, Articles.description, ARTICLEMATRIX.TIER_ID, ARTICLEMATRIX.TIER, (select art_name from articletype where...

I want to exclude rows in a query which have this as the right 7 characters '[placex' This is what I tried to use. AND (SELECT RIGHT(Articles.ByPassURL,7) <> '[placex') What is the correct syntax? Thanks for your help.

I am not familiar with the syntax to make this UDF work. I have verified that the select statements work just fine. What am I doing wrong? Thanks for your help. CREATE FUNCTION [dbo].[getContentURL] ( @Tier int, -- this is the ID of the location @Tier_ID int -- this is what level the...

How can I get DISTINCT rows returned with this setup? When I run my query like this I get DISTINCT rows. SELECT DISTINCT t.tbt_no, t.country, t.date_issued, t.products, t.final_comment_date FROM OPENDATASOURCE('SQL', 'Data Source=TSSQL;User Id=myid;Password=mypassword').mydb.dbo.thisdb t...

Hello, I am getting this syntax error from trigger and I cannot find it. (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) (0 row(s) affected) Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'd'. USE [gsigmycfsite] GO /****** Object: Trigger...

I am using a script to create audit trigger tables. however these triggers keep getting created and I do not want them created. The tables are not but the triggers are.(Layout_ChangeTracking, Notes_ChangeTracking, siteimages_ChangeTracking) SELECT @TABLE_NAME = MIN(TABLE_NAME) FROM...

I have some data that I need to convert over to proper date time format. Right now the data looks like this. 2008, July 14-18 2000, October 24 - November 4 I have about 800 rows other than doing this by hand how can I use T-SQL to accomplish this? Thanks for helping.

I am totally new to Apache. I need to create a mod_rewrite which can handle anyfile.cfm?L1=25&L2=1&L3=4 and rewrite it to anyfile.cfm/L1-25/L2-1/L3-4 I picked this up off a blog. RewriteRule ^/([A-Za-z0-9-]+)-([A-Za-z0-9-]+)/ /index.cfm?go=$1:$2 [PT,L] However, I am not sure how to modify for...