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 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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.