Welcome :Guest
Congratulations!!!

Top 5 Contributors of the Month
david stephan
yasminpriya
Ram
Gaurav Pal
christianasteves

### MDX problem: Return the number of days in a given selection/range

I've had this problem for a couple of days and found some "solutions" online. However, none of them worked. The goal is to calculate Inventory Turnover, but the problem is I can't seem to return the current number of days in the selection. The solution I found was: Count(Descendants([Date].[Date Hierachy], [Date].[Date Hierachy].[Date])) Which returned this: http://www.jandd.be/images/q_return.jpg However, I just want it to return the number of days that are in the selection, so the number of days between (incl) 22/08 and 25/09. This is a screenshot of my datedim, if it helps: http://www.jandd.be/images/q_datedim.jpg I can imagine this could be real simple or some setting that I didn't find on the dimensions, but it would be really appreciated if I could find a solution like this...

### Validate (Javascript) if input date is within this range...

I'd like to validate if the inputed date is within this range:

3 weeks before today's date to 3 weeks after today's date

The following Javascript code checks if the date is within either today's date or 2 weeks before:

```var dateSystem = (dateToday.getMonth() + 1) + dtCh + dateToday.getDate() + dtCh + dateToday.getFullYear();
var prev = new Date();
//past date 14 dates before today
prev.setDate(prev.getDate() - 14);
var pastDate = (prev.getMonth() + 1) + dtCh + (prev.getDate()) + dtCh + prev.getFullYear();
var time1 = new Date(dateSystem).getTime();
dtStr = month + dtCh + day + dtCh + year;
var dateuser = new Date(dtStr);
var time2 = dateuser.getTime();
if (time1 - time2 <= 1209600000 && time2 <= time1) {
return true;
} else {
alert("Vaccines/Services date must be within this date range: " + pastDate + " to " + dateSystem);
return false
}
return true
}```

I'm not sure how to modify. I actually got the code above from these forums.

Help is much appreciated!

### Range Validate only if it has changed

I have a scenario, where a Range Validation would fail. so I should not be validating this control  unless it has changed. I know I could use a Custom Validator, the problem is this range validator is getting added dynamically via a factory (which uses a XML). I cannot distrub this setup.

### Validate a certain number of input tags

My users will add text to be translated.
Inside the text we would like to allow a certain number of tags.
Most of them will be simple formatting but some can be extended to cover reserved words etc.

Now we would like to validate user input to ensure correct entries.

The assumption is to use HTML like formatting tags like: <b>, <br/>, <ul>, <li>, etc.
Even definitions could probably be covered by HTML if using something like: <code>, <cite>, <dfn>
This means it is fully possible to limit tags to valid HTML if that helps.

My initial guess is that Regex is faster since we will only allow a very limited number of tags.
But that validation soon becomes very complex, especially if we allow nested tags which is very much preferred and even necessary for <ul> lists.

Is there maybe a XHTML validator that might be possible to use?

I saw that TinyMCE has a similar input validation, but I am not able to detect how they actually process and apply it.
I still would prefer C# based solution over javascript.

### Disable past date, showing URL in gridview and validate generated number

Hi,

I've got 3 problems and I can't find the solution so that's why I'm here.
1. I've got a calander for adding a product to my shop. How can I make sure that you can't select a date in the past?
2. I have a gridview, and I have added a hyperlinkfield in access. When I'm filling up my gridview it doesn't show a link, it shows this:
example= www.Groezrock.be#http://www.Groezrock.be#
3. I've added a label and a textbox on my guestbook page. It says "Please fill in the number in the textbox -label that generates 4 random number- txtbox.
For filling up the textbox I use this code:

Dim randObj As New Random
lblVraag.Text = (randObj.Next(1001, 10000).ToString)

The problem is, when I fill in the number, it always gives me the validation error "Numbers don't match" which I added myself.

If txtnumbers.Text = lblnumbers.Text Then
...
Else
lblFout.Text = "Numbers don't match."

End If

### JQuery Validate plugin to validate a ASP.NET Form

The first time I used the JQuery Validate plugin, it did not work at all, see JQuery Validate odd behaviour with the ASP.NET Script Manager for reason, but perseverance and stubbornness prevailed and I finally created my first JQuery validated ASP.NET Forms contact form.

### Convert English to Arabic number without changing any regional settings in .net

Well, most applications that I worked with was multilingual that supports English UI and Arabic UI.

And one of the major issue that we have faced is displaying Arabic numbers without the need of changing the regional settings of the PC.

So the code below will help you to display Arabic number without changing any regional settings.

### dynamically adding sql server columns based on number of files in fileuploader

I want to create a new table to sql database at runtime.  The column names would be "Name", "Date", "Event".  I would also like to have one more column name "Image" but the problem is that since the amount of images will vary, I want the application to count the amount of files in the Multiple fileuploader and then add a image column to the table for the respected amount of files.

For example if i am uploading 3 files in the multiple fileuploader, the names should be "Name", "Date", "Event", "Image1", "image2", Image3"

I also would like that table name to be name dynamically from the textbox Name when the user enters the information.

I have the following code to make a new table, but I dont know how to name the fields at runtime like previously asked please help!!!

objConn.Open()

### ListViewControl - how to group items by their value, for eg. date range

Hi,

I have a table containing courses, columns are

Name - "Yoga Classes"

DateStart - "2/23/2010"

DateEnd - "2/24/2010"

I am using ListView Control to bind it, is there a way to display them and group them by Month?

for eg.

January

Piano Class (10th Jan 2010 - 11th Jan 2010)
Guitar Class (10th Jan 2010 - 11th Jan 2010)

February

Yoga Class (15th Feb 2010 - 16th Feb 2010)
etc...

Thanks for help.

### Embeb a variable number of videos

I need to provide some alternate content for my non-Flash users.

I have a directory of video files that is scanned using the DirectoryInfo() function, and I want to use the results to embed all files ending in ".mov" in QuickTime players on a web form.

How would you approach this? Right now I am using the count on the array of videos to determine how many times to repeat the embed code.  But this seems inelegant.

Is there a way to have a single QuickTime player.ascx control that gets duplicated according to the number of videos available for display?

### Article commenting by line number

I'm wondering what's the best way to approach an online article system that allows users to comment by clicking on the line they are commenting about? Essentially the same way Adobe Acrobat works with comments where you can click anywhere and the text is saved for that location.

I'm assuming a mix of jQuery would be the crux of the interface. The system would need to save comments so that when another user logs in, they will also see the other comments but they canÃÂ´t edit them - only add their own.

Any suggestions would be great.

### The number of members in the conceptual type ... does not match with the number of members on the ob

Hello,

I've added a scalar property to an entity and now ASP.NET Dynamic Data scaffolding throws this error:

## The number of members in the conceptual type 'TrainingModel.Users' does not match with the number of members on the object side type 'TrainingModel.Users'. Make sure the number of members are the same.

This happens at the following line in global.asax:
`model.RegisterContext(typeof(TrainingModel.TrainingEntities), new ContextConfiguration() { ScaffoldAllTables = true });Please help!`
Thanks

### huge number of data from database ... so how to minimize load time

Hi ...

I have used the above method to configure my crystal report ...

Its working fine , But i have huge number of data in database ....

So , it take long time to load the report ...

So , i have decided to show only the last 50 records inserted into the database , not all the 500 records to be loaded every time.

Plz help me with this issue  ...

Also , Plz explain me abt index legend in crystal report.

### Validate form input - Japanese

I've searched for several hours and haven't come up with a reference - or even many discussions - of how to go about validating Japanese names, addresses, etc. When I lived in Japan websites, atm's etc. required such info to be entered with the roman alphabet but I've seen some websites that are allowing Kanji/Hiragana/Katakana. I haven't tested many of them for validation but one that I did test (after looking at the page source and discovering no client-side validation) allowed me to put this in the name field: J*=123*go^ Neat!

Any pointers/references? Thanks

I'm getting the following error:

```[ArgumentOutOfRangeException: Value to add was out of range.
Parameter name: value]
...```

The line from which this error originates has the following code:

`expires = Now.AddDays(30)`

It occurs irregularly and irreproducably. The server date/time is correct and set to GMT. I've heard that it could be some curiosity to do with timezones, but that is speculative.

It seems that we're some time from the year 10,000 yet, so I can't understand why adding thirty days to the current time could cause this! Any ideas? Culture settings perhaps?

### How i find out light and dark color range??

Hi,

I am showing preview of text in text box.

But if text color is light(Like white) and i want to show that text preview than text is not visible because textbox background color is white.

Can i get the range of dark and light color so i'll change textbox backgroun color accordingly.

### How to show 0 as first number in column

Hi guys. I have two little problem.

I have database with one table and it has 4 rows.

1. I want to show a zero in front of all number. Actually i added but it doesn't show.

2. If i don't put any value in column is it possible to have minus for example instead of 0?

http://dox.bg/files/dw?a=632de0c7c6

http://dox.bg/files/dw?a=c98fc6df8c

http://dox.bg/files/dw?a=83fb8efbba

I post it like that because i can't see how to post pics directly.

P.S. The columns with numbers have checked "allow nulls".

I draw in paint so it's not so good but i think it's understandable.