Developer forum

Forum » Development » Database Publishing - Custom SQL

Database Publishing - Custom SQL


Reply

Hi there

 

As the headline say, I'm trying to make a Custom SQL string in the Database Publishing Module where I use the standard SQL-function "Dateadd".

 

Which you normally build like this:

DATEADD (datepart , number, date )

 

In my example it is: 

 

dateadd(year, (year(date()) - year(dato)), dato)

 

But gives me the error:

Sql test: No value given for one or more required parameters.

 

What am I doing wrong?

 

I'm using it to build a "Birthday Database", if someone has a another way to get the output I need - I'm all ears

 

-kim

 


Replies

 
Reply

This error occurs because there's something wrong with your statement. Please evalulate the complete statement and correct any errors. The problem is not with DBPub.

 

You must be logged in to post in the forum