# Database gurus please look.  Non-nerds need not click

**URL:** <https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198>\
**Category:** PittSpeed Off Topic\
**Created:** [June 17, 2004, 12:20pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198 "2004-06-17T12:20:48Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![S10Blazed\_Si](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/s10blazed_si/32/5983_2.png) [@S10Blazed\_Si](https://forums.speedlife.net/u/S10Blazed_Si)\
**Post date:** [June 17, 2004, 12:20pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/1 "2004-06-17T12:20:48Z")

</div>

I’ve been teaching myself how to make simple databases for crap here at work. We have about a bajillion old drawings in a seperate building and we’re scanning them in and putting them to disk… yadda yadda yadda. So I made a way to add them into the database and was lookin to tweak it a bit. This is where i need help. If you’re familiar with some aspects of this let me know. Here is the URL. [http://www.widmerengineers.com/archives/](http://www.widmerengineers.com/archives/) I know it’s not as cool as [pittspeed.com](http://pittspeed.com) but oh well. My main question concerns adding entries into the database. Some of the fields are s’posed to be multiple choice and would like a pulldown menu instead of a text entry field. I’m stumped on this one…

---

<div class="post-metadata">

**Author:** ![fshowcars](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/fshowcars/32/5937_2.png) [@fshowcars](https://forums.speedlife.net/u/fshowcars)\
**Post date:** [June 17, 2004, 12:28pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/2 "2004-06-17T12:28:33Z")

</div>

so something like

\<option selected value=“add\_value”\>input data here \</option\>  
\<option value=“archive\_location”\>Location\</option\>  
\<option value=“title”\>Title\</option\>  
\<option value=“sheet\_number”\>Sheet Number\</option\>  
\<option value=“archive\_location”\>Archive Location\</option\>  
\<option value=“sheet\_number”\>Sheet Number\</option\>  
\<option value=“ddate”\>Date\</option\>

---

<div class="post-metadata">

**Author:** ![S10Blazed\_Si](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/s10blazed_si/32/5983_2.png) [@S10Blazed\_Si](https://forums.speedlife.net/u/S10Blazed_Si)\
**Post date:** [June 17, 2004, 12:34pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/3 "2004-06-17T12:34:10Z")

</div>

specifically I would like drawing type to be a 3 option pulldown with WIDMER, QUAD, and NON-WE as options.

---

<div class="post-metadata">

**Author:** ![fshowcars](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/fshowcars/32/5937_2.png) [@fshowcars](https://forums.speedlife.net/u/fshowcars)\
**Post date:** [June 17, 2004, 12:38pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/4 "2004-06-17T12:38:15Z")

</div>

plug n play

\<input TYPE=“hidden” NAME=“VTI-GROUP” VALUE=“0”\>

\<p\>\<font color="#008080"\>\<b\>\<br\>  
File Name\</b\>\<br\>  
\<input name=“file\_name” size=“50” value="" maxlength=“50”\>\<br\>  
\<b\>Archive Location\</b\>\<br\>  
\<input type=“TEXT” name=“archive\_location” size=“50” value="" maxlength=“50”\>\<br\>  
\<b\>Title\</b\>\<br\>  
\<input type=“TEXT” name=“title” size=“50” value="" maxlength=“50”\>\<br\>  
\<b\>Sheet Number\</b\>\<br\>  
\<input type=“TEXT” name=“sheet\_number” size=“50” value="" maxlength=“50”\>\<br\>  
\<b\>Job Number\</b\>\<br\>  
\<input type=“TEXT” name=“job\_number” size=“50” value="" maxlength=“50”\>\<br\>  
\<b\>Date\</b\>\<br\>  
\<input type=“TEXT” name=“ddate” size=“50” value=“6/17/2004”\>\<br\>  
\<b\>Comments\</b\>\<br\>  
\<input type=“TEXT” name=“notes” size=“50” value="" maxlength=“64”\>\<br\>  
\<b\>Drawing Type\</b\>\<br\>  
\<option selected value=“Drawing Type”\>types of drawings? \</option\>  
\<option value=“type\_1”\>WINDMER\</option\>  
\<option value=“type\_2”\>Quad\</option\>  
\<option value=“type\_3”\>Non-WE\</option\>  
\<input type=“TEXT” name=“company” size=“50” value="" maxlength=“50”\>\<br\>  
\<b\>Coordinates\</b\>\<br\>  
\<input type=“TEXT” name=“coordinates” size=“50” value="" maxlength=“50”\>\</font\>\<br\>  
\</p\>

---

<div class="post-metadata">

**Author:** ![Darkstar](https://avatars.discourse-cdn.com/v4/letter/d/b487fb/32.png) [@Darkstar](https://forums.speedlife.net/u/Darkstar)\
**Post date:** [June 17, 2004, 12:39pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/5 "2004-06-17T12:39:30Z")

</div>

databases are for pussies

---

<div class="post-metadata">

**Author:** ![fshowcars](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/fshowcars/32/5937_2.png) [@fshowcars](https://forums.speedlife.net/u/fshowcars)\
**Post date:** [June 17, 2004, 12:39pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/6 "2004-06-17T12:39:39Z")

</div>

that would get you a drop down…don’tknow about the input string… guess i’d have to play around with it… plus html editing via notepad ownz

---

<div class="post-metadata">

**Author:** ![S10Blazed\_Si](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/s10blazed_si/32/5983_2.png) [@S10Blazed\_Si](https://forums.speedlife.net/u/S10Blazed_Si)\
**Post date:** [June 17, 2004, 12:54pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/7 "2004-06-17T12:54:43Z")

</div>

cool, I got it…

[http://www.widmerengineers.com/submission\_form2.asp](http://www.widmerengineers.com/submission_form2.asp)

---

<div class="post-metadata">

**Author:** ![whitey](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/whitey/32/5911_2.png) [@whitey](https://forums.speedlife.net/u/whitey)\
**Post date:** [June 17, 2004, 12:56pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/8 "2004-06-17T12:56:07Z")

</div>

i can help you when i am at home, you are using asp its really easy!

---

<div class="post-metadata">

**Author:** ![S10Blazed\_Si](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/s10blazed_si/32/5983_2.png) [@S10Blazed\_Si](https://forums.speedlife.net/u/S10Blazed_Si)\
**Post date:** [June 17, 2004, 12:58pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/9 "2004-06-17T12:58:42Z")

</div>

Thanks whitey. I might have some more questions as I get more involved. I know asp is easy, thats why I chose to use it. I learned some SQL and Oracle in school but I didn’t retain that knowledge too well.

---

<div class="post-metadata">

**Author:** ![ninjenn](https://avatars.discourse-cdn.com/v4/letter/n/c67d28/32.png) [@ninjenn](https://forums.speedlife.net/u/ninjenn)\
**Post date:** [June 17, 2004, 12:59pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/10 "2004-06-17T12:59:36Z")

</div>

EDIT: everyone else beat me to it… I typed too slow.

---

<div class="post-metadata">

**Author:** ![fshowcars](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/fshowcars/32/5937_2.png) [@fshowcars](https://forums.speedlife.net/u/fshowcars)\
**Post date:** [June 17, 2004, 1:17pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/11 "2004-06-17T13:17:10Z")

</div>

so i was on the right track… \<option\> is all that is needed… woot

yay for a programming-hater

---

<div class="post-metadata">

**Author:** ![whitey](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/whitey/32/5911_2.png) [@whitey](https://forums.speedlife.net/u/whitey)\
**Post date:** [June 17, 2004, 2:08pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/12 "2004-06-17T14:08:49Z")

</div>

i got books on SQL if you ever need me to reference anything

---

<div class="post-metadata">

**Author:** ![fshowcars](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/fshowcars/32/5937_2.png) [@fshowcars](https://forums.speedlife.net/u/fshowcars)\
**Post date:** [June 17, 2004, 2:14pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/13 "2004-06-17T14:14:36Z")

</div>

i can install and implement a SQL server… :dunno:

---

<div class="post-metadata">

**Author:** ![Darkstar](https://avatars.discourse-cdn.com/v4/letter/d/b487fb/32.png) [@Darkstar](https://forums.speedlife.net/u/Darkstar)\
**Post date:** [June 17, 2004, 7:38pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/14 "2004-06-17T19:38:50Z")

</div>

> [@turbovw18](#):
>
> i can install and implement a SQL server… :dunno:

I can install a cock…

in your ass… :dunno:

---

<div class="post-metadata">

**Author:** ![BlkP42E](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/blkp42e/32/5938_2.png) [@BlkP42E](https://forums.speedlife.net/u/BlkP42E)\
**Post date:** [June 17, 2004, 8:26pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/15 "2004-06-17T20:26:28Z")

</div>

im going to have to do some referance this summer. my work wants me to add to thier webpage the ability to make reservations on-line. sounds like a pain, but after taking a look at this doesnt seem too bad

---

<div class="post-metadata">

**Author:** ![whitey](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/whitey/32/5911_2.png) [@whitey](https://forums.speedlife.net/u/whitey)\
**Post date:** [June 17, 2004, 8:58pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/16 "2004-06-17T20:58:10Z")

</div>

> [@BlkP42E](#):
>
> im going to have to do some referance this summer. my work wants me to add to thier webpage the ability to make reservations on-line. sounds like a pain, but after taking a look at this doesnt seem too bad

in what language? get them to run [asp.net](http://asp.net) and you could have it running in like a day once you learned the language

---

<div class="post-metadata">

**Author:** ![BlkP42E](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/blkp42e/32/5938_2.png) [@BlkP42E](https://forums.speedlife.net/u/BlkP42E)\
**Post date:** [June 17, 2004, 9:21pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/17 "2004-06-17T21:21:29Z")

</div>

whatever language i want. its part of my internship to redesign the webpage, then they want me to add it so people can make reservations online. any reccomidations on books to learn [asp.net](http://asp.net)??? id like to learn seeing that ill graduate in a semester and its the new hot thing.

here is the current page  
[http://www.highlandcc.net/](http://www.highlandcc.net/)

and whitey, since you like golf you should look into joining highland, right now they are trying to attract younger members and its crazy cheap. like $100/mo with no minimum

---

<div class="post-metadata">

**Author:** ![Darkstar](https://avatars.discourse-cdn.com/v4/letter/d/b487fb/32.png) [@Darkstar](https://forums.speedlife.net/u/Darkstar)\
**Post date:** [June 17, 2004, 11:06pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/18 "2004-06-17T23:06:01Z")

</div>

🤣

We should all join for a month and see how long it takes us to get thrown out.

---

<div class="post-metadata">

**Author:** ![ninjenn](https://avatars.discourse-cdn.com/v4/letter/n/c67d28/32.png) [@ninjenn](https://forums.speedlife.net/u/ninjenn)\
**Post date:** [June 18, 2004, 4:37am UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/19 "2004-06-18T04:37:23Z")

</div>

> im going to have to do some referance this summer. my work wants me to add to thier webpage the ability to make reservations on-line. sounds like a pain, but after taking a look at this doesnt seem too bad

Ouch… if they want the credit card info and stuff you’ll have to make it secure. I don’t know how to do that stuff. Never needed to know.

---

<div class="post-metadata">

**Author:** ![BlkP42E](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/blkp42e/32/5938_2.png) [@BlkP42E](https://forums.speedlife.net/u/BlkP42E)\
**Post date:** [June 18, 2004, 2:50pm UTC](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198/20 "2004-06-18T14:50:46Z")

</div>

> [@huskysgrl](#):
>
> Ouch… if they want the credit card info and stuff you’ll have to make it secure. I don’t know how to do that stuff. Never needed to know.

nah cause the entire club just runs on chits, and bills them at the end of the month

[Next page](https://forums.speedlife.net/t/database-gurus-please-look-non-nerds-need-not-click/167198.md?page=2)