I have created a list in WSS 2.0 and pulled in a field from another list on the site.
I have then edited a particular view of this list by converting to XSLT and making some minor modifications.
However when i now look at this XSLT view it shows the data, but all the views shown are those...
Does anyone know how I can use the date functions within SQL to return the rows where a specific date value is "any time in the previous calendar month"
e.g. if it was run now it would return everything from 01/08/06 to 31/08/06 inclusive.
Thanks in advance
I have an application with a simple form which populates a backend SQL database. At the moment I can enter as much information as i like but if I go over the database field limit it gets truncated.
Is there a way I can specify the number of characters allowed at the data entry satge.
A...
Thanks Scheco, however using reporting services 2005 I was able to do it without having to pass the parameters to the sproc.
For the size of the dataset i'm returning this will be approriate for now.
I need to be able to use the multiple parameters option on one of my reports, however when i do this the stored procedure fails to return any records.
I suspect this is because it is passing incorrect syntax back to the SP. e.g. My IN clause will be epecting ('xxxx', 'yyyy', 'zzzz') but i...
Hi All,
for some reason my Shared Data Sources fail to deploy stating my username has insufficient permissions to perform the operation.
This used to work a few weeks ago and I cannot think of any chages which have been made to my user credetials on any of our servers.
Does anyone know which...
Hi,
Does anyone have any ideas on how I can search through a number (hundreds) of sub directories on a file system looing for a particulary ini file in each directory and if it is found then return the directory it is in?
I have had a look using the FSO objects but cannot get it to work...
I wonder if anyone can shed a light on this query for me?
here's a brief overview:-
SQL Server, Reporting Services and IIS are all on one development box - I point my local browser to the reporting service homepage URL and my published reports appear as expected.
If I select a report...
I was kindly advised how I could send an auto email from .net yesterday by Ruffnekk, however on implementing this code I still have problems whereby the mapiobject isn't supported and access is denined.
I am running this in conjuction with an exchange2003 server. The error message I receive is...
Thanks Ruffnekk, but using this still gives me the same error whcih leads me to believe i'm missing something within my project, it falls ove on the line
SafeItem.Recipients.Add("xxx@xxxxxxx.com") - (With my correct email address) stating:-
System.Runtime.InteropServices.COMException...
I am trying to send an automatic email to bypass the outlook security model by using the Redemption objects which I have dowloaded from the web.
However the code I have doesn't seem to work, I'm not sure if this is missing some important code or wheter the syntax isin't relevant for a .Net...
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.