im not too sure how i should be storing the SQL2000 timestamps
basically i return a dataset which is used to populate an editable grid.
this dataset contains the timestamp. how should i be storing the timestamps
for each grid row? is it possible to hold them in the grid in someway? or do
i need to look at other means
ive only used Oracle Timestamps before and they where just decimal
timestamps which made it easy!! could just store them in the grid in a
hidden column.
any help would be greatly appreciated
Cheers,
Craig 4 2165
You could use a boundcolumn and change its visiblity to false through
the Visible property. However, why do you really need to store it as a
hidden value?
----
- Wilco Bauwer
Blog & Custom Controls @ http://wilcoding.xs4all.nl
i need to hold/use it for concurrency.
if i do hold it in a boundcolumn then how do i get it out? my other columns
are template columns and i can just find the values using
CType(e.Item.Fi ndControl("lblA ttendanceHeader ID"), Label).Text
"Wilco Bauwer" <wi****@gmail.c om> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. . You could use a boundcolumn and change its visiblity to false through the Visible property. However, why do you really need to store it as a hidden value?
---- - Wilco Bauwer Blog & Custom Controls @ http://wilcoding.xs4all.nl
Almost the same thing. Just inspect what's inside e.Item.Cells. There
should be a cell which either directly contains the datetime value, or
a literal or something which holds it.
----
- Wilco Bauwer
Blog & Custom Controls @ http://wilcoding.xs4all.nl
sqlserver timestamps are binary data (actually a bigendin 8 byte integer).
load it into a byte array, which you can base64 encode and store in a
hidden field.
-- bruce (sqlwork.com)
"Craig G" <craig.gamble@y _arrasoftware.c om> wrote in message
news:uE******** ******@TK2MSFTN GP09.phx.gbl...
| im not too sure how i should be storing the SQL2000 timestamps
|
| basically i return a dataset which is used to populate an editable grid.
| this dataset contains the timestamp. how should i be storing the
timestamps
| for each grid row? is it possible to hold them in the grid in someway? or
do
| i need to look at other means
|
| ive only used Oracle Timestamps before and they where just decimal
| timestamps which made it easy!! could just store them in the grid in a
| hidden column.
|
| any help would be greatly appreciated
|
| Cheers,
| Craig
|
| This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: lkrubner |
last post by:
This might be an idiot question, but how do you group by timestamps by
date? I mean, given a large number of timestamps, spanning many months,
how do grab them and say how many are from each day? If the timestamps
measure visits to a web site, how to easily say there were 45 visits on
January 4th?
The first idea that occurs to me is to put them all in an array and
then loop through the array and use date() on each, one at a time,...
|
by: richardd |
last post by:
Hi,
I am writing code to deal with PCAP files. I have a PCAP dump and I am
looking at the timestamps in the PCAP packet headers to see if they are in
the correct order in the file. To do this I have a class called
PCAPPacketHdr as follows
import struct
class PCAPPacketHdr:
FormatString = "LLLL"
|
by: Craig Wahlmeier |
last post by:
Am I the only one in the world that selects dates and timestamps with
OLEDB?
V8 of UDB has brought me a big problem.
The PATCH2=24 setting no longer works the way it used to. The
settings of MAPDATEDESCRIBE=1, MAPTIMEDESCRIBE=1, and
MAPTIMESTAMPDESCRIBE=1 allow me to reverse that V8 change, almost.
Before V8, the format of a date column returned in OLEDB was based
upon the regional settings of the client. Now, it returns it in...
|
by: Chumma Dede |
last post by:
Hi,
I need to code a DLL in .NET which logs the response times for our asp.net
multi-tier application. The problem is we need to log the timestamps at
multiple stages in a process lifecycle roundtrip without too much overhead.
We have two webservers which are load balanced and the back end tiers
include Biztalk and several remoting components all of which should ideally
use this same dll for logging timestamps in a central location in...
|
by: ameshkin |
last post by:
Hi GUys,
Im trying to compare two dates in MYSQL. But its not treating the
dates as numbers, but as strings. I try using strtotime but that did
not work.
Basically, if the last comment is newer than the last user login, then
I need for a message to pop up and say New Comments.
If not, then no new comments. The area of this code which is not
working is at the bottom.
| |
by: Brandon |
last post by:
I'm using PHP with MySQL 4.x and was having trouble converting a
datetime from MySQL into a formatted string until I ran across this
solution that converts a YYYY-MM-DD HH:MM:SS string into a Unix-style
timestamp and then formats it.
$timestamp = "2005-04-06 15:43:34";
$time = strtotime($timestamp);
print date('Y-m-d \a\t H:i', $time)."\n";
However, it seems kind of counter productive. After all, aren't people
|
by: mike_dba |
last post by:
I am looking for SQL syntax that will enable me to subtract quarters
from timestamps. Any suggestions?
Pseudo-code example -
YEAR( timestamp_column - 9 Quarters)
I know that I can easily subtract things like DAYS. However, I can't
seem to be able to manipulate using Quarters.
|
by: maruk2 |
last post by:
I have some old data files with old timestamps, where
timestmap=time(NULL), some of them date back to the
year 1999.
I want to my code to print the timestamps and each one to
include hour:minute:second as of the corresponding old day.
The only routine for this job seems to be
localtime(timestmap) - this is Windows Vista,
Visual Studio 2005 C++.
|
by: xkenneth |
last post by:
All,
Just a quick question. I want to be able to have a data structure
that organizes data (timestamps I'm working with) sequentially, so
that i can easily retrieve the first x amount of timeStamps without
iterating over a list. My thought was to use a binary tree, am i
overthinking the problem to try and implement this structure inside of
python? I was also hoping this would already be done for me.
Regards,
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |