|
well u have an item in the orders table i assume
and u would have a delivery days table no?
then when something is going to be delivered on a particular day u would assign the date or day_id of the delivery date to the item delivery date field in the items table and bump up the count for that delivery day entry by one
or thats how i would do it
"there is no spoon"
biz stuff about me
|
|
|
|
|
Yes I have orders table, but no deliveries table. I didn't think it was necessary. I'm looking into what you are saying so I can understand better. Does that mean I would need to add 200 fields to the table and if they are filled then go to anether record?
This is killing me, sorry.
|
|
|
|
|
oh shame ... im sorry ur going mad with this
ok heres what i would do
make a table called deliveries
columns (all i can think of right now):
delivery_id (auto-number)
delivery_date (date)
num_booked (int)
then in ur item / order / whatever table add a column
delivery_id (int)
when ur looking for the next free delivery slot search thru the deliveries table for a num_booked less than 200 (make sure its after now() datewise)
set the item delivery_id column to the delivery date id u found and bump the delivery date record num_booked up by 1
when u cancel a delivery for a date bump the num_booked down by one
then u want a section in the cms to add delivery dates and voila!
hope that helps
"there is no spoon"
biz stuff about me
|
|
|
|
|
After playing and playing and not understanding what you were saying because I'm not that good at asp, I finally figured it out.
What I did was, I converted dates into a string, searched for dates and counted the dates that mathched, that gave me the right record count. Then I took your select statment and now its a beautiful, fully functional piece of code.
Thanks for all your help Lauren,
Take Care,
Eleonora
|
|
|
|
|
nice work, chik...
"Your village called -
They're missing their idiot."
|
|
|
|
|
I want to get param from an textbox then pass it to applet. How to solve this problem?
The code below do not take effect.
function get_param(String textt){
document.applet_name.param_name.value=textt;
}
|
|
|
|
|
Hi
I have created a simple Http Server that is imbedded in a desktop application in order to provide an easy way to present various documents via an imbedded browser. All works well, however I have noticed that when serving a PDF doc the browser (pdf plugin I guess) connects to the server twice and downloads the doc twice (only one displays). All other doc types (xls, txt) only create one connection and do one download. Can anyone shed any light on why PDFs behave this way ??
Thanks,
Patrick_H
|
|
|
|
|
Check the User-Agent header. I have a sneaking suspision that one connection it IE and the other is Acrobat. Since the plugin architecture changed for Acrobat (Reader) sometime back, it does behave a little differently, although it is supposed to reuse the same moniker. Who knows.
The only other thing I can think of is that Acrobat as of the last couple versions "streams" the document so that you can get the first couple pages without waiting for the whole thing. It's possible that this second connection is required to make that happen (for whatever reason).
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
Hello,
I would like to put a panel at the top of my web page which spans the entire width of the page. Here is the code I have:
<asp:Panel id="Panel1" style="Z-INDEX: 102; LEFT: 0px; POSITION: absolute; TOP: 0px" runat="server" Width="100%" Height="48px" Wrap="False">
</asp:Panel>
For some reason, when this is rendered in IE, it leaves a quarter inch of space on the right side near the vertical scroll bar. If I set the width=110%, it spans the entire screen, but then a horizontal scroll bar appears. Is there any particular reason this is happening? The same thing happens when I set other objects to have a width of 100% (ex. horizontal rule, table, etc). How do I get rid of this problem?
Thanks for your help,
RC
|
|
|
|
|
This is a stylesheet problem. You should set the padding to 0 and possibly the margin to 0. This has to do with the box format that CSS uses.
So, to your style attribute add padding:0px;margin:0px.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
Sounds like you've got the default padding on the page. Add html,body { padding: 0; margin: 0 } to your stylesheet and you should be good to go.
- Mike
|
|
|
|
|
One other thing that you might want to try is setting the rightmargin attribute of your body tag to "0".
HTH,
Bill P.
Oakland, CA
|
|
|
|
|
Hi all,
My Web server is IIS6 running on a windows 2000 server. I am trying open a document from an ASP Page. The problem I am facing is in clients other than windows 2000 the word file is not opening. Some clients if it opening with format mismatch error.
When I checked the Windows 2000 clients where I am getting the output, the file association for ASP is with Win Word. The other clients this entry is not there. ( My computer -> View -> Folder Options -> Files Association). Now if I manually put this entry still the format mismatch is coming.
How to solve this??
Thanks and Regards,
Satya Prasad
|
|
|
|
|
Are you sending the appropriate MIME type (HTTP's Content-Type header)? You should set the response's Content-Type to "application/msword".
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
Hi,
Yeah I initially set the Content Type to "application/msword". It was opening word but without any output, so I changed that to "application/winword". Then I got the output in only Windows 2000 clients, other clients I could not get the output. Any suggestions??
Regards,
Sayta.
|
|
|
|
|
The version of Windows doesn't matter - only the version of IE and Office (IE is what associates MIME handlers while one of the Office products is being opened). So, are all the versions of IE the same? How about Office?
Have you also tried downloading the file via a simple user agent (using the PERL mod LWP, .NET BCL's System.Net.WebClient, or something else) to see what it contained? Perhaps there's an error generating the file that you're not seeing or the binary output is corrupted (possibly the Content-Length header isn't correct either, thus causing corruption).
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
Hi,
The client Windows2000 with Office 2000, alone is getting the page displayed. Why I mentioned OS is because with Win NT workstation Office 2000 installed on it, I could not get the page. Coming to IE in all the clients IE 5.0 or later.
I am putting my code snippet here.
<% Response.buffer= true
Response.ContentType = "application/msword" %>
<% dim conn,rs
set conn=Server.CreateObject("ADODB.Connection")
conn.open "dsn here"," "," " %>
' Putting a query here
set rs=conn.execute("Select xxxx")
' Writing the output to a html table in a loop
Thanks and Regards,
Satya Prasad
|
|
|
|
|
Wait, you're outputing HTML? The MIME type should be "text/html" then. While Word can open HTML docs, when you tell it the MIME type is "application/msword", it's no surprise that it's failing. If you want to open the document in Word, you could have a link that invokes a script (in the local or Intranet zone, this should work) that causes Word to open the document itself. Since it, too, can read "text/html" documents it will handle it appropriately. But telling Word that it's to read something in one format when it's really another is bound to lead to problems.
There's several articles here on CP that show you how to open a document in Word. Pass a URL instead of a file path and you should be okay:
<script language="jscript">
var word = new ActiveXObject("Word.Application");
word.Open(url);You'll want to double-check the code, though.
There are examples on the 'net (even here on CP) that do the same thing you're trying, but like I said - when you tell Word that it's opening a word document when it's really opening an HTML file, expect the unexpected.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
|
Tom Archer wrote:
How can I change the icon that appears in the IE address bar for my site? I know CP had such a thing a while back and it's gone now.
Put an icon named favicon.ico in your root directory. 
Tom Archer wrote:
Also on a related note, if you drag the Google URL to the links band, the Google icon appears on the band. How is this done?
Same way.
|
|
|
|
|
In addition to what jdunlop said, you should also add a LINK tag in your HEAD for pages. This is actually the standard:
<head>
...
<link rel="shortcut icon" type="image/x-ico" href="/favicon.ico">
<head> You can also use ref="icon" and different types, like PNG, GIF, and JPEG of the appropriate sizes this way, and use images in different places (if you like to keep all images together, for instance).
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
Hello,
I am looking into charting components for ASP.NET - There seem to be quite a lot of products out there - But I have a specific requirement so if anyone can help me out (and short circuit my search) I'd be really pleased.
Specifically the charting tool needs to be able to plot a scatter plot with a best fit curve. Both scatter plot and best fit curve must be displayed on the same plot. The function for the best fit curve must be custom defined. If the charting component cannot accept a custom best-fit curve function then the other option would be the ability to put two plots on one chart and a series of plot points can be provided to allow a reasonable approximation to be generated.
Any ideas would be greatly appreciated.
Regards,
Colin.
--Colin Mackay--
"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)
|
|
|
|
|
Quoting GOTDOTNET.com:
http://samples.gotdotnet.com/quickstart/aspplus/doc/debugcomsdk.aspx
"Because many parts of an ASP.NET Framework application are dynamically compiled at runtime (.aspx and .asmx files, for example).."
What does aspx file compiled to? I thought "code behind" is compiled into "dll" and placed in the "bin" directory of the web app (virtual) directory when you first build the project.
Do they mean rendering "aspx" into "Html"?
|
|
|
|
|
Yes, code-behind files are compiled into DLLs, but ASP.NET files (like aspx) need not use code-behind. Any server-scripting in an aspx file (or ascx, asmx, or anything else similar) in the page itself must be compiled and is done so at runtime with the first access of the page / control after the application object is created. The compilation can be controlled via the <compilation> configuration section under <system.web>.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
Heath Stewart wrote:
is done so at runtime with the first access of the page /
Thanks for feedback. But, what do you mean it's compiled at first hit? The "ASPX' file is "COMPLIED" into HTML?? I know XXX.aspx.cs is compiled into a dll. But not the "aspx" itself. That's the confusing part.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
