Hello fellow developers!

In the office we got into a discussion on how you should store a zip code in a database. In Denmark zip codes are just 4-digit numbers like: 8340 or 6400.

Would you store them as strings or would you store them as integers?

Regards
Soeren

If there is an even remotely risk that the system at any time needs to store addresses outside of Denmark, I would store them as strings.

Some countries have letters in the zip codes, swedish zip codes are five digits but they are written with a space between the third and fourth digit.

---
b { font-weight: normal; }

Hi all, I have lately started doing some development on ASP.

Anyways,
I have installed interdev 6.0 at home and office. But the interface for ASP editor looks very different at home.

At home Visual Interdev does not have that 3 tabs, at the bottom i.e. design, source and quick view. While the Interdev at office has those tabs.

Any idea how to enable that feature in Visual Interdev or have I missed installing some components.

I have IIS and ASP script engine installed at home on Windows 2000.

The same problem is there with Microsoft frontpage too.

Confused | :confused:

Thanks in advance.

-Prakash

-- modified at 6:16 Monday 16th January, 2006

Well i resolved the problem, I uninstalled and reinstalled the visual interdev component of VS6.

i guess it somehow got screwed up by installing/uninstalling of VS.NET

Things are nice and good.

Is there any suggestion on a good ASP editors (except for notepad or texpad kinda stuff Smile | :)

)?

Thanks again.

-Prakash

Does anybody knows how to implement spell checking in ColdFusion OR Perl ?

Sorry, I missed your post. I hope this response is not too late.

For PERL, I've used Speller Pages[^] with success.

For ColdFusion, I've used Jazzy[^] wrapped in a Java class as described in this article[^].

"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty

Hi! Yes I know that this is brutal off-topic, but I realy need help. I want begin to programmig an internet aplications in Flash. Web sites designeds in flash. I dont know how does it works. I have experience with C, C++ and C# as well as with PHP and later i turned into .NET - ASP.NET. If somebody has usefull suggestions, please send me an email. If not, just ignore this ask Smile | :)

Thanks a lot
Lukas

Error msg that I get now running my ASPX page (With graphics stuff in created in Dreamweaver)

All was running fine. Had .NET installed. All working. Had to change the access permissions on my folders to allow IUSER_SERVER access so that my DB's will work. (WHICH they now do) BUT since I have changed my access permissions, my ASPX page just gives me this error msg. Any ideas? What would the access permissions have to do with this and how to fix it?

ERROR :
Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.

Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.

CODE: ASPX Page
<%@ Page Language="C#" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<mm:dataset
id="DataSet1"
runat="Server"
isstoredprocedure="false"
connectionstring="<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_STRING_loginaccess"] %>"
databasetype="<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_DATABASETYPE_loginaccess"] %>"
commandtext="<%# "SELECT * FROM Users" %>"
debug="true"
="">
<mm:pagebind runat="server" postbackbind="true">
<%@ Register TagPrefix="Portal" TagName="ImageCanvas" Src="ImageCanvas.ascx" %>
<%@ import Namespace="System.Drawing" %>

void Page_Load(Object sender, EventArgs e) {
Pen newpen = new Pen(Color.Black);
Bitmap bitmap4 = new Bitmap(300,300);
Graphics g4 = Graphics.FromImage(bitmap4);
g4.Clear(Color.White);
g4.DrawLine(newpen,5,5,20,20);
g4.DrawLine(newpen,5,5,50,5);
ImageCanvas4.bitmap = bitmap4;
}

<portal:imagecanvas id="ImageCanvas4" runat="server" imagetype="Jpeg">

And still more info

CODE : ASCX PAGE
<%@ Control Language="C#" %>
<%@ import Namespace="System.Drawing" %>
<%@ import Namespace="System.Drawing.Imaging" %>

public Bitmap bitmap;
public ContentType ImageType = ContentType.Jpeg;

void Page_Load(Object sender, EventArgs e) {

if (Request.Params[ID] != null) {
Response.Clear();
Response.ContentType = "Image/" + ImageType.ToString();
bitmap.Save(Response.OutputStream,getFormat((int)ImageType));
Response.End();
}

String Url = Request.Url.ToString();
if (Url.IndexOf("?") == -1) {
DyImage.ImageUrl = Url + "?" + ID + "=Show";
}else{
DyImage.ImageUrl = Url + "&" + ID + "=Show";
}
}

ImageFormat getFormat(int i){
ImageFormat imgfmt = ImageFormat.Jpeg;
switch(i){
case 0:
imgfmt = ImageFormat.Gif;
break;
case 1:
imgfmt = ImageFormat.Jpeg;
break;
case 2:
imgfmt = ImageFormat.Png;
break;
}
return imgfmt;
}

public enum ContentType{
Gif=0,Jpeg=1,Png=2
}

<asp:image id="DyImage" runat="server">

this is me

Hello World!,

I want to order the data of each column in a table when clic on the header of the column.

I try with:

http://www.glendinning.org/webbuilder/sortTable/

but have problem with the data type int and string.

gangeles

Thank you, I find an better example:

http://www.kryogenix.org/code/browser/sorttable

gangeles

Hello Dear,
I am having problem on generating report from my Web Application,
I am using ASP/SQL 2000/Crystal Report 9.1
When I start generate report from my asp page it throw an error like
Error Occurred creating Report Object: Object required, Err.No: 424
What is the problem how to solve this situation...?

N.Rajakumar B.E.,
Application Developer,

-- modified at 5:25 Friday 13th January, 2006

The background:
We have an internal order management system which is running as a web application. In the next generation of our system, I want to incorporate a WorkFlowManager subsystem. As I see it functioning -- I want this to function as an observer for state changes in specific data items. It then moves an item into the next workflow state and notify the person/group responsible for that stage of the flow.

What I need to accomplish is this:

I thought of running a component in the background on peoples workstations that would sit as a listener waiting for a message from the workflow manager. It would then show a box that a work item exists in the workflow queue for them to review and they have to respond to the request.

The issue:

I need to have a way to know that a user in a particular roll is touching the web .. it may be specifically the workflow web. I then need to check and see if my communicator is on their machine, and if not push it to them. And this is where my ASP.NET skills fall short. Any suggestions on doing this check-and-push approach ???

Thanks,
Michael

Please don't cross post.

---
b { font-weight: normal; }

I'm looking to setup a forum. I'd like to hear any recommendations people have for software! I'm a good C++ developer, but my web development is very limited (I can edit HTML and modify existing code, but I've never written new code for the web), so I'm looking for something REALLY easy to setup.

So far the best I've seen are:

1)Web Wiz
http://www.webwizguide.info/asp/default.asp[^]

2)Instant ASP
http://kb.instantasp.co.uk/article.aspx[^]

I'd like a "hosted" version if possible, or for "non-hosted" I'd like to use godaddy.com if possible, as I already have a website there.

As long as it's < $1000 cost isn't a big issue.

Any comments would be greatly appreciated! Smile | :)

Thanks

Warren

So you want Forum software???

Why not use phpBB or vBulletin? (Free and commercial)

It's frustrating being a genius and living the life of a moron!!!

You might try looking at Telligent's community server package. there are various licences available including free to non profits Big Grin | :-D

http://communityserver.org/

It's used by the guys at #develop and it seems to work very well.

End of Line.

When I try to run an update query via ASP to an Access DB, I get the error below. The insert query works fine when I run it from Access, but not ASP. I can read from the DB fine, but can't write to it.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/Tutorial/guestbook.asp, line 43

Code:
<% @Language=VBScript %>

<title>Guest Book

<%
IF request.form ("Message")="True" THEN
strTB1=request.form("To")
strTB2=request.form("EMailAdd")
strTB3=request.form("CC")
strTB4=request.form("Subject")
strMB1=request.form("Memo")
IF strMB1 = "" THEN
iLenMB1=255
ELSE
iLenMB1 = Len(strMB1)
END IF
'Connects to the Access driver and Access database in the Inetpub
'directory where the database is saved
strProvider = "Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Inetpub\Wwwroot\Tutorial\guestbook.mdb;"
'Creates an instance of an Active Server component
set objConn = server.createobject("ADODB.Connection")
'Opens the connection to the data store
objConn.Open strProvider
'Instantiate Command object and use ActiveConnection property to
'attach connection to Command object
set cm = Server.CreateObject("ADODB.Command")
cm.ActiveConnection = objConn
'Define SQL query
cm.CommandText ="INSERT INTO Guestbook (TB1,TB2,TB3,TB4,MB1) VALUES (?,?,?,?,?)"
'Define query parameter configuration information for guestbook fields
set objparam=cm.createparameter(, 200, , 255, strTB1)
cm.parameters.append objparam
set objparam=cm.createparameter(, 200, , 255, strTB2)
cm.parameters.append objparam
set objparam=cm.createparameter(, 200, , 255, strTB3)
cm.parameters.append objparam
set objparam=cm.createparameter(, 200, , 255, strTB4)
cm.parameters.append objparam
set objparam=cm.createparameter(, 201, , iLenMB1, strMB1)
cm.parameters.append objparam
cm.execute
response.write("Thank you!")
ELSE%>

Guestbook

To

Email Address

CC

Subject

Message

<%End if%>

Thanks!

Check that the account used by IIS has write access on the directory where the MDB file is.

Your "write access" tip led me in the right direction. Turns out "users" did not have write permission to one of the folders in the path to the database. Thanks a bunch!

hi all,
i ve a asp listbox control in my webpage.
i need to find the number of items in that list box using javascript?

is it possible?
it doesnt contain any option1, option2 ....

with regards
Crazy

CrazySanker

All I ever wanted is what others have

theListBox.options.length

---
b { font-weight: normal; }

I am looking for a simple template(kind of black & white) for my weblog on blogger.com. Something like a newspaper, but very simple and professional. Do you know any?

Thanks in advance
-Maysam

-- modified at 1:40 Thursday 12th January, 2006

Hi
Go to Yahoo!
search for Yahoo! site builder and download it
this program helps you to build and construct your website in prof. way
and you can use the template provided

Best Wishes
Regards

Mohammad Rabay'a

Hi ...

Im using the code from
http://www.dddekerf.dds.nl/DHTML_Treeview/DHTML_Treeview.htm

and I need to modify it to have hyperlinks to nodes with the + sign, I cant seem to get that done - any idea anyone?

Thanks!

hi,

I have a dataSet and I am binding the dataset to the table.The data set may have more number of rows(20) and columns(10).I want to have a scrollable grid that shows only 5 rows and 4 coulms and if the user needs to see more he has to scroll left or right.

How can make the grid scrollable to left and right.Till now what I did is that I got the data set and I bind it to the DataGrid I am seeing all the rows and columns.How to proceed further.

can any one help me in this.

Thanks,
Satish.

Web Development

Guestbook