Example
#{example}"); ipb.editor_values.get('templates')['togglesource'] = new Template(""); ipb.editor_values.get('templates')['toolbar'] = new Template(""); ipb.editor_values.get('templates')['button'] = new Template("
Emoticons
"); // Add smilies into the mix ipb.editor_values.set( 'show_emoticon_link', false ); ipb.editor_values.set( 'bbcodes', $H({"snapback":{"id":"1","title":"Post Snap Back","desc":"This tag displays a little linked image which links back to a post - used when quoting posts from the board. Opens in same window by default.","tag":"snapback","useoption":"0","example":"[snapback]100[/snapback]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"0","optional_option":"0","image":""},"topic":{"id":"5","title":"Topic Link","desc":"This tag provides an easy way to link to a topic","tag":"topic","useoption":"1","example":"[topic=1]Click me![/topic]","switch_option":"0","menu_option_text":"Enter the topic ID","menu_content_text":"Enter the title for this link","single_tag":"0","optional_option":"0","image":""},"post":{"id":"6","title":"Post Link","desc":"This tag provides an easy way to link to a post.","tag":"post","useoption":"1","example":"[post=1]Click me![/post]","switch_option":"0","menu_option_text":"Enter the Post ID","menu_content_text":"Enter the title for this link","single_tag":"0","optional_option":"0","image":""},"spoiler":{"id":"7","title":"Spoiler","desc":"Spoiler tag","tag":"spoiler","useoption":"0","example":"[spoiler]Some hidden text[/spoiler]","switch_option":"0","menu_option_text":"","menu_content_text":"Enter the text to be masked","single_tag":"0","optional_option":"0","image":""},"acronym":{"id":"8","title":"Acronym","desc":"Allows you to make an acronym that will display a description when moused over","tag":"acronym","useoption":"1","example":"[acronym='Laugh Out Loud']lol[/acronym]","switch_option":"0","menu_option_text":"Enter the description for this acronym (EG: Laugh Out Loud)","menu_content_text":"Enter the acronym (EG: lol)","single_tag":"0","optional_option":"0","image":""},"hr":{"id":"12","title":"Horizontal Rule","desc":"Adds a horizontal rule to separate text","tag":"hr","useoption":"0","example":"[hr]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"1","optional_option":"0","image":""},"php":{"id":"14","title":"PHP Code","desc":"Allows you to enter PHP code into a formatted/highlighted syntax box","tag":"php","useoption":"0","example":"[php]$variable = true;\n\nprint_r($variable);[/php]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"0","optional_option":"0","image":""},"html":{"id":"15","title":"HTML Code","desc":"Allows you to enter formatted/syntax-highlighted HTML code","tag":"html","useoption":"0","example":"[html]\n \n[/html]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"0","optional_option":"0","image":""},"sql":{"id":"16","title":"SQL Code","desc":"Allows you to enter formatted/syntax-highlighted SQL code","tag":"sql","useoption":"0","example":"[sql]SELECT p.*, t.* FROM posts p LEFT JOIN topics t ON t.tid=p.topic_id WHERE t.tid=7[/sql]","switch_option":"0","menu_option_text":"","menu_content_text":"","single_tag":"0","optional_option":"0","image":""},"xml":{"id":"17","title":"XML Code","desc":"Allows you to enter formatted/syntax-highlighted XML code","tag":"xml","useoption":"0","example":"[xml] 6 Replies - 85 Views - Last Post: Today, 10:55 AM Rate Topic: 
#1 Adqusit ?
Reputation: 0
- Posts: 38
- Joined: 02-March 13
Posted Today, 03:02 AM
Hi. I'm using DatetimePicke on my SaleInfo form, for inserting the Date and Time of Sale. The dataType of Sale_Date field in SQL Server 2005 is DateTime. I set the DTP format property to short and then to its original default to Long but in both the cases, when i insert the data so only date is displayed validly but the time is fix to 12:00:00 AM. In Addition to this, i changed its value property (which is originally 3/22/2013 2:59 PM, but i removed the time from the value property). Now please tell me that what is this problem, why the current date and time both are not inserting properly? Please guide me.
Is This A Good Question/Topic? 0
Replies To: Why dateTimepicker is not showing proper date and time in Database
#2 CharlieMay ? 
Reputation: 1284
- Posts: 4,138
- Joined: 25-September 09
Re: Why dateTimepicker is not showing proper date and time in Database
Posted Today, 03:44 AM
if you don't supply a time to a datetime it defaults to 12am if you want the time just use the .Value of your datetimepicker upon insertion into the database. Value will put the current time in
#3 Adqusit ?
Reputation: 0
- Posts: 38
- Joined: 02-March 13
Re: Why dateTimepicker is not showing proper date and time in Database
Posted Today, 06:14 AM
Can't i put the value property to its default value?
#4 CharlieMay ?
Reputation: 1284
- Posts: 4,138
- Joined: 25-September 09
Re: Why dateTimepicker is not showing proper date and time in Database
Posted Today, 06:22 AM
OK, DateTimePicker. It's used to hold a well, a date and time (or a TimeStamp if you prefer)As a developer, you have access to a datetime structure which is what is returned from the DataTimePicker's .Value property.
This means that you can break it down even further by specifying .Date which appears to be what you're doing.
Assume you have a datetimepicker with the following showing in the textfield "03/22/2013"
DateTimePicker1.Value will be equal to #03/22/2013 09:17:00 AM#
DateTimePicker1.Value.Date will be equal to #03/22/2013#
DateTimePicker1.Text will be equal to "03/22/2013"
When you ONLY put a date into a database field that has a type of Date|DateTime|TimeStamp the field will replace a non-existant time with midnight
If you need a time then as you can see above, passing the value will place the current time into the field without changing the format of your datetimepicker.
So change the input into the database for the datetimepicker to .Value not .Value.Date
#5 Adqusit ?
Reputation: 0
- Posts: 38
- Joined: 02-March 13
Re: Why dateTimepicker is not showing proper date and time in Database
Posted Today, 06:46 AM
Dear Charlie. I deleted the old DTP and add a new one on my form and then started insertion of data so you know i just change the format to short and did nothing to its value property and when i check the last inserted records, so its fulfilling my need i.e. the current date and current time of insertion is there in DataBase. I think the problem i am facing with my old DTP is that i modify the value property and removed the time from it on design mode, therefore it inserts the fix time i.e. "12:00". In this case if i bring the value property to its default value, on which it is, when it is added first time on form.or in other case, as you mentioned.
I want this value back in value property #03/22/2013 09:17:00 AM#. I am totally baffle that what to do now, Charlie. I am sorry but i'm not understanding anything.. 
#6 CharlieMay ?
Reputation: 1284
- Posts: 4,138
- Joined: 25-September 09
Re: Why dateTimepicker is not showing proper date and time in Database
Posted Today, 06:55 AM
If I remember correctly, you are inserting these from a DataTable that you create and populate with the entry. Then you loop through the datatable and insert the field into the database. Is that correct?If that is correct, look at where you're inserting the date into the database and make sure that you are also inserting time.
#7 Adqusit ?
Reputation: 0
- Posts: 38
- Joined: 02-March 13
Re: Why dateTimepicker is not showing proper date and time in Database
Posted Today, 10:55 AM
yes its correct. Yes time is available for all of the records. But with some records, the correct time is available and for some records the fix time i.e. 12:00 Am or PM.
Page 1 of 1
dallas weather nike nfl uniforms ben and jerrys free cone day tornado in dallas texas the island president the maldives harper lee
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.