A cumbersome (perhaps cool)SQL can be worked out but it might be
cleaner maintenance-wise to write a simple store procedure to handle your
listing
Just loop for N-times going back 7 days per loop and within that
do your counting should be just a few lines
Ciao
tifoso
Last Activity: Mar 5 '08, 06:10 AM
Joined: Apr 11 '07
Location: Easy St
-
Washed
Not sure if you want to handle the submit in your client or on the server
To call the a javascript for pre-digesting just use the AddAttributes to your button
and add an Onclick to your javascript function and do your stuff
Clicking the asp:button will submit it and you can handle that on the Page_load
check out the Page.IsPostBack and u should be good to go
...Leave a comment:
-
If u try and show some code more help will come your way
Open an object(Excel type) , browse to the sheet/columns you are interested
and insert into your table
CiaoLeave a comment:
-
Have the cron job call a perl script is quicker/cleaner get stat of each file on the folder(s) and compare the dates to current system time and move it properly
CiaoLeave a comment:
-
It sounds like you dont want to run the ALTER TABLE but just want to chop the
contents of the field, if so you can even do this in the update query to table 2
but KISS would go like this
update table1
set longer_fieldie = substr(longer_f ieldie, 1,100)
CiaoLeave a comment:
-
I guess when you say if it exists you mean there is a value, the field itself always exists.yoyu don't say if A is a string or numeric so can't give you more than this
select f1,f2,
CASE WHEN A is not null then A ELSE B END
from wacked_table
CiaoLeave a comment:
-
There are a few ways to accomplish it, done something like that on quick and dirty mode and it goes like this: you can browse thru the open apps ands once you FIND the IE browser you grab its handler, set the focus on it, [it may not work on a real browser like fireFox ;-)]
play with a series of keystrokes to highlight and grab the URL copy it on to the clipboard and there you go.
The name for the find API is a bit funny...Leave a comment:
-
You can do it with a store procedure and loop thru your records sorten alphabeticaly or if you want to be cool via trigger just make sure it is well written
as it might be a performance issue if not clean
pseudo code goes like this:
cusor select f1m f2 from table order by f1
loop thru cursor and insert appropiately changing your counter when first character changes
deallocate...Leave a comment:
-
Take the bloody sum out if all you need is those 2 fields added, sum is for a different use RTFM a bit more
select f1,f2, ... , f2 +f3 , ... blah blah blahLeave a comment:
-
.NET makes a bit easier but in VB6 u can use a web object set it to the URL and grab the HTML from there and parse it at your own will ... keep in mind that HTML from Outlook is quite messy on their main login screen I was modifying that code and i was not pretty.
CiaoLeave a comment:
-
Although Access is a bit of toy DB it does some of the basic ANSI sql stuff just run this query in your vba
select * into table_copy from source_table
you may want to turn off the warnings before and after you execute the query
CiaoLeave a comment:
-
Even if you get it to work it is a bit unreliable and depending on machine where you run it and network load. I've done a couple of things just like that when you run the debugger it is slower so it works when you run from the page your EXE.App gets blown away by the keys and it doesn't have time to handle the 1st key stroke. You can tweak it by placing a delay in between key strokes
I'd look for an API or something like that for...Leave a comment:
-
Although u can run it by hand your script can't , rights issue assuming your syntax is OK. I found out even if you own the file sometimes it cannot delete files, once
I had to chmod the files so it'd go thru
CIaoLeave a comment:
-
A bit blurry on your question but let me give it a shot: If you have rights(actually your App) then I'd assume you are trying to read some file off the network drive???
Referring the network drive with UNC should be all you need on top of the rightsLeave a comment:
-
If u launch the excel from VB6 yes since from inside you'd create an excel object
and hence you can do anything with Excel, then record a a macro with the stuff you need to happen in Excel, grab that code an embed it into your VB probably with a couple of little tweaks and there u go.
CiaoLeave a comment:
-
When an Update or delete from access issues pop up this is the quick an dirty
way (very old code but still works)
sSQL = "INSERT INTO table blah blah"
On Error GoTo failed_insert:
DoCmd.SetWarnin gs (False)
DoCmd.RunSQL sSQL
DoCmd.SetWarnin gs (True)Leave a comment:
-
You have to do some work ;-) search for the proper connect string and use that
to get onto your oracle DB, if u get issues post your code and help will come your wayLeave a comment:
-
A bit blurry but it sounds like u r stating u get the values from a result set as a string so there is not setting that will help you there. Probably you should get the values with full year and keep them so in your code at moment of displaying format it to to show a shorter date
CiaoLeave a comment:
-
it depends on the type of field you need to elaborate more on that, it sounds like you may have char or varchar field and if it allows nulls u go by this
...
where field ='' or field is nullLeave a comment:
-
OK I also looked at the Queue and Stack but in this case accessing to elements in the middle e.g. elts starting at n thru n+mini_page positions seem to be available by the enumerator type but I'm not sure about the performance of those???
Any pointers here would be great. I still would like to get the Arraylist shifting as I can see it could useful somewhere else.
CIaoLeave a comment:
No activity results to display
Leave a comment: