Re: Re[4]: lug-bg: Linux, Novell and Dosemu

2002-11-17 Thread Иво Тачев 
15.11.2002 ã. 18:33:46, "Petar Markov" <[EMAIL PROTECTED]> wrote:

>
>OK! :-) Koia versia na Dosemu? Kato root ili kato user? Neshto v
>dosemu.conf-a koeto da se otbeleji? (enable ili disable na IPX, Netware
>hacking .. i pochie?)
>

dosemu 1.1.3.0 compiled from source
âúðâè êàòî root - çàñåãà òàêà ñàìî ìè ðàáîòè âñè÷êî, èíà÷å ìíîãî íåùà íå ìîãà äà 
ãè ïîäêàðàì (êëàâèàòóðåí äðàéâåð â DOS, boot îò ðåàëåí dos partition è ò.í.). Å, 
êàòî ìè îñòàíå âðåìå ïî-íàòàòúê ùå ãî áîðÿ è êàòî user.
Íàñòðîéêè â dosemu, êîèòî èìàò îòíîøåíèå:
---
.
$_xms = (1024)  # in Kbyte
$_ems = (2048)  # in Kbyte
$_ems_frame = (0xe000)
$_dpmi = (off)  # in Kbyte
...
$_irqpassing = "10" # list of IRQ number (2-15) to pass to DOS such as
...
$_rawkeyboard = (1) # bypass normal keyboard input, maybe dangerous
...
$_keybint = (on)# emulate PCish keyboard interrupt
...
$_video = "vga" # one of: plainvga, vga, ega, mda, mga, cga
$_console = (1) # use 'console' video
...
$_ports = "range 0x300,0x31f"   # list of portnumbers such as "0x1ce 
# 0x1cf 0x238"
# or "0x1ce range 0x280,0x29f 310"
# or "range 0x1a0,(0x1a0+15)"

$_ipxsupport = (off)# or on
$_novell_hack = (off)
$_vnet = (off)  # 'on' for packet-multi (used by dosnet)
---

>Ne che e mnogo vajno no koi Linux s kakav kernel i kakvia versia na NCPFS e
>bila opitnata postanovka na koiato e iztestvano i se tvardi che raboti
>stabilno?
>

Mandrake 8.2
kernel 2.4.17 patched with nwfs and badram from WOLK patches (òîâà, ðàçáèðà ñå, 
íÿìà îòíîøåíèå â ñëó÷àÿ, ïðîñòî ìè å êåô äà ïóñêàì ñ MARS-NWE åìóëèðàí netware 
òîì âúðõó èñòèíñêè traditional Netware partition íà õàðääèñêà)
êîíôèãóðèðàí ñ: IPX=y è IPX_INTERNAL_NETWORK=n (çàðàäè MARS-NWE)
ncpfs 2.2.0.18
mars-nwe compiled from source îò ñúîòâåòíèÿ Mandrake SRPM êúì äèñòðèáóöèÿòà 
(òîâà å çàðàäè ïîääðúæêàòà íà rcprn - GPL remote mars-nwe printer for DOS, ñúùî 
çàðàäè äîêóìåíòàöèÿòà - â Mandrake RPM ñà ñëîæèëè îò ñòàðà âåðñèÿ è íå âúðøè 
ðàáîòà)

>
>Kato se ima predvid cenata na edna LAN smiatam che tona ne e problem (moje
>bi e dosta po -goliam problem e oshte edin port na hub-a ili PC s ISA :-)))
>

Íåîáõîäèìîñòòà îò ISA è îùå åäíà òî÷êà îò LAN äåéñòâèòåëíî å íåïðèÿòíî 
îãðàíè÷åíèå, àìà êîãàòî íÿìà íà÷èí èíà÷å...

>Probvai ako mojesh da go "zabiesh" tova dos- prilojenie pls :))
>

Ùå ïðîáâàì ïî-íàòàòúê êàòî èìàì âðåìå, ïîâúðòÿõ ãî äîñòà, ðàçïðàùàõ ñúîáùåíèÿ 
ñúñ SEND ìåæäó ñòàíöèÿòà è êîíçîëèòå íà èñòèíñêèÿ ñúðâúð è íà MARS-NWE. Ñåãà 
èìàì èäåÿ êàê ìîãà äà ãî íàêàðàì äà çàáèå - ùå íàâúðæà äà ðàáîòÿò ñ ïðèëîæåíèåòî 
îùå åäíà-äâå DOS ñòàíöèè è ñúùåâðåìåííî ùå íàïðàâÿ RW äîñòúï äî íÿêîé îò 
ôàéëîâåòå íà BTRIEVE-ñêàòà áàçà îòêúì linux êëèåíòà.

>
>NAI-VAJNOTO E CHE takava mashina (pusnata kato client) moje da se access-va
>ot VSIAKADE... edin terminal pod niakakva forma i gotovo...
>
>==>>Vzimash edim free Linux, puskash mu edin free mars novell server kam
>koito moje da se log-vat kakvito ti dusha iska klineti (dos, Win, i kakto
>veche stana iasno Linux) i ne na posledno miasto niakoi ot tezi Linux
>klienti gi konfigurirash za remote dostap (pri tova v telnet rejim za da
>niama problem pri drop na vrazkata:-))) i taka pestish i ot Novell Connect i
>vaobshte dtava sladka LAN pri tova stable :-)))
>

Å, çà òàêàâà óïîòðåáà íå ñå áÿõ çàìèñëèë, íàèñòèíà òîâà å öåííî (ñàìî íàèñòèíà 
äà ñå ïîäêàðà dosemu êàòî user)!






A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html

Re: Re[4]: lug-bg: Linux, Novell and Dosemu

2002-11-17 Thread Иво Тачев 
>> Eto opisanie na sluchaja:
>> Linux PC s 2 LAN karti - 1 ISA i 1 PCI, i dvete zakacheni na edin i syshti
>> Ethernet segment. Na Ethernet segmenta ima zakachen i Netware (3.X, 4.X,
>> 5.X...) server. Linux raboti s PCI kartata i ne znae za syshtestvuvaneto na
>> ISA kartata, t.e. kernel modules za PCI kartata, IP i IPX protokoli,
>> prilozhenija vyrhu tjah... V DOSEMU pyk si se raboti vse edno che e chist
>> DOS - LSL,  (v sluchaja NE2000), IPXODI, VLM ili NETX i t.n.
>> Mogat da se polzvat SPX utilities kato RCONSOLE, RPRINTER/NPRINTER, kakto i
>> DOS prilozhenija iziskvashti SPX, naprimer BTRIEVE requester.
>> Ednovremenno s tova Linux syshto mozhe da e client na syshtija Netware
>> server - ncpmount, ncpprint i t.n. Za Netware servera, kakto i za Ethernet
>> izobshto, tova sa dvama razlichni useri ot dva razlichni adresa, vse edno
>> ot dve razlichni mashini. Pri tova IPX e po edin i syshti frame (v sluchaja
>> 802.3) i na dvete platki. V Linux mozhe vmesto client da se pusne mars-nwe
>> netware server emulatora - za sharing na fajlove i printeri na Linux
>> mashinata. Vsichko tova raboti stabilno na 100%, nedostatyk e samo
>> neobhodimostta ot otdelna ISA mrezhova platka samo za DOSEMU.
>
>Oppa oppa oppa . nqkoj e v zabluzhdenie tuka ;-)
>Neka da vidim dali sym az ;-) 
>Neka uto4nim malko nestata ... Zna4i kazvash 4e imash Linux PC s 2 lan karti 
>-- ednata PCI i druga ISA , kato  Linux nqma zareden driver (module) za ISA 
>kartata ... Kak se polzva tazi karta, pone na men ne mi stana qsno ... 
>Moeto obqsnenie bi bilo slednoto (mozhe i da gresha, de;-)
>1. Vsi4ko minava prez mrezhoviq interface na PCI lan kartata, a ISA wyobste 
>nikoj ne q polzwa za nisto, taka li e ?

Otkym DOSEMU clienta si vyvrvi prez ISA platkata s ODI drivera, a v Linux client 
ili MARS-NWE server neshtata si minawat prez PCI platkata (tja dazhe e ne2k-pci 
i se zarezhda i kernel-modula 8390.o). Tova e fakt, zashtoto na konzolata na 
Netware jasno se vizhdat razlichnite mrezhovi adresi na clientite, koito sa na 
edna mrezha (ne sym promenjal nishto, taka che IPX network number = MAC 
address).

>2. Tova obqsnqva i fakta 4e ne e nastypila boza pri vkarvaneto na 2 mrezhovi 
>interface-a na edna machina e edin i systi ethernet segment, bez polzvaneto 
>na proxy-arp (koeto systo mozhe da e opasno)... Anyone ?
>

Mislja, che tova samo pokazva, che DOSEMU e po-skoro x86 emulator, a ne samo DOS 
emulator...

>
>IPX/SPX za slozhni kato specifikaciq i posle kato implemantaciq ... TCP/IP e 
>star i izpitan kolkoto sveta i e otnositelno prost i dosta nadezhden, mozhe 
>bi i za tova se e nalozhil ... Ina4e nqma losho za IPX/SPX, no q si predstavi 
>celio Internet da se gradi vyrhu nego ;-) ... Ta az sym protiv IPX/SPX -- 
>slozhnoto ne vinagi e wiser solution ;-), i se polzva samo po prinuda, i to s 
>adski debeli argumenti ... 
>

Razbira se, che po-prostoto e po-stabilno, a i Internet otdavna e izgraden vyrhu 
TCP/IP - ne stava vypros da se razbutva neshto, koeto e napraveno i raboti 
dobre. Imam predvid izpolzvaneto na IPX/SPX v LAN - tam, kydeto ne se polzvat 
Internet-tehnologiite i/ili ima security concerns.

--
Èâî Òà÷åâ
"ÅÑÊÎÐÒ" ÑÄ - êîìïþòúðåí ñåðâèç
òåë. /02/963-04-05






A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html

Re: lug-bg: Sorry

2002-11-17 Thread Theodor Milkov 
On Sat, Nov 09, 2002 at 09:53:29PM +0200, Teodor Georgiev wrote:
> 
> kato stana vypros za obyrkvane na listove, imam nqkolko pitaniq:
> 
> 1. Vidqh che ima Solaris user Group, opitah se da se aboniram za
> lista, ama nishto ne stana. Opitah da pratq i e-mail -> vyrna mi
> greshka, che takyv e-mail nqma. Nqkoi da znae poveche info za tova?
>
> 2. Ne e li dobra ideata da se syzdade otdelen list za networking
> kudeto da se diskutirat otdelno vsichki non-linux vyprosi, kato NAS,
> routers, switches, wireless AP i prochie hardware, network
> protocols...

Ne vidiah niakoi da otgovaria na tozi e-mail, a men tezi vaprosi sashto
jivo me valnuvat. Opitah se da se subscribe za niakakv cisco related
mailing list @ zonebg.com (niakolko pati), no neshto ne se poluchi...

> Ili dori i otdelen za Windows. Znae se mnenieto na vsichki tuk za
> Windows kato OS, no ne mozhe da se otreche che mnogo ot nas po
> edna ili druga prichina dovolno chesto im se nalaga da si imat
> vzemane-davane s neq.

Niakoi ima li informacia za drugi interesni mailing lists?

-- 
Theodor MilkovNetwork Administrator
Davidov Net   Phone: +359 (2) 730158

A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html

Re: lug-bg: Sorry

2002-11-17 Thread Teodor Georgiev 


- Original Message -
From: "Theodor Milkov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, November 17, 2002 5:08 PM
Subject: Re: lug-bg: Sorry


> On Sat, Nov 09, 2002 at 09:53:29PM +0200, Teodor Georgiev wrote:
> >
> > kato stana vypros za obyrkvane na listove, imam nqkolko pitaniq:
> >
> > 1. Vidqh che ima Solaris user Group, opitah se da se aboniram za
> > lista, ama nishto ne stana. Opitah da pratq i e-mail -> vyrna mi
> > greshka, che takyv e-mail nqma. Nqkoi da znae poveche info za tova?
> >
> > 2. Ne e li dobra ideata da se syzdade otdelen list za networking
> > kudeto da se diskutirat otdelno vsichki non-linux vyprosi, kato NAS,
> > routers, switches, wireless AP i prochie hardware, network
> > protocols...
>
> Ne vidiah niakoi da otgovaria na tozi e-mail, a men tezi vaprosi sashto
> jivo me valnuvat. Opitah se da se subscribe za niakakv cisco related
> mailing list @ zonebg.com (niakolko pati), no neshto ne se poluchi...
>
> > Ili dori i otdelen za Windows. Znae se mnenieto na vsichki tuk za
> > Windows kato OS, no ne mozhe da se otreche che mnogo ot nas po
> > edna ili druga prichina dovolno chesto im se nalaga da si imat
> > vzemane-davane s neq.
>
> Niakoi ima li informacia za drugi interesni mailing lists?
>

DA :)  vypros tukmo na mqsto.
Osnova se nov list (wizh t.2) specialno za takiva neshta. Shtoto naprimer da
se raziskva BGP, ili 3COM switchove,
VoIP i t.n. si e meko kazano kofti. A pyk neshta kato Active Directory i
prochie Windows osobici si e gavra s trup.
Vse oshte e nov, no otiva na dobre.
S cel da izbiagna eventualen gniav ot "spam"a, shte se vyzdyrzha ot reklama
:)



A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html

lug-bg: MySQL query

2002-11-17 Thread Teodor Penev 
zdrasti lug-bg,

imam slednoto pitane:
MySQL tablica s razlichni poleta -

++--+
| id  | name|
+-+-+
| 1   | joe |
+-+-+
| 2   | jane|
+-+-+
| n   | bill|
+-+-+


celta e da vzema stoinostta na nai-goliamato 'id' (n)
(ili poslednoto) i da go vkaram v php code.
neshto kato SELECT id FROM table ORDER BY id WHERE id = '...'
...
posle da uvelicha biggest id + 1 za nov zapis i t.n.
predpolagam che moje da se vikat stoinosttie na id (vsichkite)
v php i posle da se vzema nai-goliamato, no ne moga da go izmislia
v momenta...

any ideas? 10x


-
http://imot.GBG.bg - Èìîòúò, êîéòî òúðñèòå.

A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html

Re: lug-bg: MySQL query

2002-11-17 Thread Ted Zlatanov 
On Sun, 17 Nov 2002, [EMAIL PROTECTED] wrote:
> zdrasti lug-bg,
> 
> imam slednoto pitane:
> MySQL tablica s razlichni poleta -
> 
> ++--+
> | id  | name|
> +-+-+
> | 1   | joe |
> +-+-+
> | 2   | jane|
> +-+-+
> | n   | bill|
> +-+-+
> 
> 
> celta e da vzema stoinostta na nai-goliamato 'id' (n)
> (ili poslednoto) i da go vkaram v php code.
> neshto kato SELECT id FROM table ORDER BY id WHERE id = '...'
> ...
> posle da uvelicha biggest id + 1 za nov zapis i t.n.

Защо не използваш auto_increment?

CREATE TABLE names (
name varchar(200),
id int(11) auto_increment not null,
PRIMARY KEY (id)
);

След това, като запишеш ново име, MySQL ще увеличи ID със 1
автоматично.  Просто не използвай ID-то когато записваш името.

Ако ти трябва максимумът все пак, виж

http://www.mysql.com/doc/en/example-Maximum-column.html

Теодор


A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html

Re: lug-bg: MySQL query

2002-11-17 Thread Emil Slavov 
SELECT MAX(id) AS id FROM tablicata
Da pravish takava selekcia na PHP e podigravka s MySQL-a :)
Slogi si auto_increment opcia za colonata id ako iskash da se uvelichava 
avtomatichno pri vseki nov zapis. Inache na raka s INSERT.

zdrasti lug-bg,

imam slednoto pitane:
MySQL tablica s razlichni poleta -

++--+
| id  | name|
+-+-+
| 1   | joe |
+-+-+
| 2   | jane|
+-+-+
| n   | bill|
+-+-+


celta e da vzema stoinostta na nai-goliamato 'id' (n)
(ili poslednoto) i da go vkaram v php code.
neshto kato SELECT id FROM table ORDER BY id WHERE id = '...'
...
posle da uvelicha biggest id + 1 za nov zapis i t.n.
predpolagam che moje da se vikat stoinosttie na id (vsichkite)
v php i posle da se vzema nai-goliamato, no ne moga da go izmislia
v momenta...

any ideas? 10x


-
http://imot.GBG.bg - Èìîòúò, êîéòî òúðñèòå.

A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html




A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html

Re: lug-bg: Toshiba Portege 7020 CT; PCMCIA CD-ROM non-bootable

2002-11-17 Thread George Danchev 
On 16 11 2002 11:51, Nickola Kolev wrote:
> Íà ñá, 2002-11-16 â 09:39, George Danchev çàïèñà:
> > Hi,
> > laptop Toshiba Portege 7020 CT. CD-ROM e vynshen i zaka4en na PCMCIA
> > slot.
>
> A vmesto da se mychish, zashto ne si napravish boot disketka s net
> support i ne otrazish edin mrezhov install? Estestveno, tuk se
> podrazbira, che trebe da ti se namira nekyv eth device...

;-)Vsystnost az zabravih da poqsnq 4e distro install-a ne e bash problem..;-)
Osven preneseniq MDK installed ot druga machina, ve4e ima installed i RH7.3 
(make 2 diskette images, vtorata s pcmcia drivers i boot ot tqh, otkri 
pcimcia cdrom device i po-natatyk prodylzhi cdrom diska ...;-). Sigurno ste 
upgrade do rh 8.0 ako mozhe, ako ne reinstall rh8.0... sled tova install i 
oste nesto . i na posledniq 4-ti post ot stafetata zadylzhitelno ste 
"bqga" debian, veroqtno netinstall ... Kakto i da e, tova ne e interesno ...

Problema e 4e, se nalaga tozi pcmcia cdrom da e bootable device, za da ne 
zavisim ot dock station, floppy i hdd (edno hdd s distrota, vtoroto s prazni 
fs'es za user data, ednovremenno i dvete hdd nqma mqsto kyde da se bodnat 
oba4e)   T.e. v naj-loshiq slu4aj da mozhe da boot ot pcmcia cdroma 
zavyrshena sistema kato Knoppix i eventualno po zhelanie da mount nqkakvi 
fs'es ot hdd ako ima v momenta nqkakvo hdd (i/ili floppy) ... 

Ta eventualno reshenie, osven tozi btmgr.sf.net s kojto za sega ne uspqvame da 
boot ot pcmcia cdrom-a (a pishe 4e trebe da mozhe) , da se vidi kakvo mozhe 
da pomogne GRUB kato boot manager (ne kernel loader) za da set-ne boot ot 
pcmcia cdroma (stoto biosa ne go mozhe) , no za sega oste ne sme kopali po 
tozi vypros, no imam 4uvstvoto 4e nqma da pomogne mnogo ;-)... Ta ako nqkoj 
ima opit s grub i kak da mu se obqsnqva tova da kazva ;-)

10x 

-- 
Greets, fr33zb1 
[catching up with Sid (the boy next door who destroyed toys :-)]
[reg your bg translation or grab one from http://www.bgit.net/?id=37892]


A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html

Re: Re[4]: lug-bg: Linux, Novell and Dosemu

2002-11-17 Thread George Danchev 
On 17 11 2002 16:43, Èâî Òà÷åâ wrote:

> >Neka uto4nim malko nestata ... Zna4i kazvash 4e imash Linux PC s 2 lan
> > karti -- ednata PCI i druga ISA , kato  Linux nqma zareden driver
> > (module) za ISA kartata ... Kak se polzva tazi karta, pone na men ne mi
> > stana qsno ... Moeto obqsnenie bi bilo slednoto (mozhe i da gresha, de;-)
> >1. Vsi4ko minava prez mrezhoviq interface na PCI lan kartata, a ISA
> > wyobste nikoj ne q polzwa za nisto, taka li e ?
>
> Otkym DOSEMU clienta si vyvrvi prez ISA platkata s ODI drivera, a v Linux

Zna4i iskash da kazhesh 4e v tozi slu4aj na machinata imash ISA karta za koqto 
Linux kernela nqma support, a DOSEMU (user-space prilozhenie, raboteshto pod 
systiq tozi Linux) upravlqva ISA kartata samostoqtelno sys sobstven driver, 
bez znanieto na Linux kernel-a kojto upravlqva cqlata machina... Tova 
teoreti4eski trqbva da e vyzmozhno (mozhe bi i opasno?), no az naistina ne 
znaeh 4e DOSEMU e tolkova napred s materiala ... ako tova naistina e taka, 
huh. T.e. device driver v user-space pod monolythic kernel, blah ... Ot 
predniq mail systo ne mi stana qsno kak tova driver4e nameri ISA kartata ili 
mozhe bi napravo access-va na4alnite adresi ot pametta (tezi predi 16-tiq MB, 
zadeleni za ISA DMA) . Nisto ne razbirah . No kakto i da e ... Nqma 
zna4enie ;-)

> client ili MARS-NWE server neshtata si minawat prez PCI platkata (tja dazhe
> e ne2k-pci i se zarezhda i kernel-modula 8390.o). Tova e fakt, zashtoto na
> konzolata na Netware jasno se vizhdat razlichnite mrezhovi adresi na
> clientite, koito sa na edna mrezha (ne sym promenjal nishto, taka che IPX
> network number = MAC address).
>
> >2. Tova obqsnqva i fakta 4e ne e nastypila boza pri vkarvaneto na 2
> > mrezhovi interface-a na edna machina e edin i systi ethernet segment, bez
> > polzvaneto na proxy-arp (koeto systo mozhe da e opasno)... Anyone ?
>
> Mislja, che tova samo pokazva, che DOSEMU e po-skoro x86 emulator, a ne
> samo DOS emulator...

Da, no DOSEMU pyrvo e potrebitelsko prilozhenie koeto spored moite razbiraniq 
raz4ita na Linux kernela za da access-va hardware-a . a ina4e e qsno 4e 
se pravi na x86 PC (i boot-va naj-dobre FreeDOS image), kakto WmWare syzdava 
machina, za razlika ot WINE kojto emulira OS.

-- 
Greets, fr33zb1 
[catching up with Sid (the boy next door who destroyed toys :-)]
[reg your bg translation or grab one from http://www.bgit.net/?id=37892]


A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html

RE: lug-bg: MySQL query

2002-11-17 Thread Peter An. Zyumbilev 

Kolegite tuk za sa pravi za auto_increment.
i az tak pravaia prosto naistibna e mnogo udobno, no normalnite hora ne
praviat taka...
zaradi problemi s "delete"...Kato iztriesh pole i ako ima auto_incremt ti
ostava "dupka"...
v MS Sql ima sturotia za resetvane na ID-to no pri mysql ne si spomniam dali
ia imashe ili ne...
ama togav stavat edni kashi...
Mislia che niama nisto losho da si go napravsih po tvoia  nachin.
zaivakate e:
select count(1) from my_table.
umishleno ne ti kazvam
select count(*) from my_table.
pri oracle tazi zaivka e po-bavna...
alternativa razbira se select max(colone);
kato skorost mislia che
select count(1) from my_table.
e nai barzata
Pozdravi,
BIVOL


Peter Angelov Zyumbilev
Web Developer & Administrator
web: http://www.bivol.net 
email: [EMAIL PROTECTED] 
tel. : + 359 88 966940



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Teodor Penev
Sent: Sunday, November 17, 2002 7:29 PM
To: [EMAIL PROTECTED]
Subject: lug-bg: MySQL query


zdrasti lug-bg,

imam slednoto pitane:
MySQL tablica s razlichni poleta -

++--+
| id  | name|
+-+-+
| 1   | joe |
+-+-+
| 2   | jane|
+-+-+
| n   | bill|
+-+-+


celta e da vzema stoinostta na nai-goliamato 'id' (n)
(ili poslednoto) i da go vkaram v php code.
neshto kato SELECT id FROM table ORDER BY id WHERE id = '...'
...
posle da uvelicha biggest id + 1 za nov zapis i t.n.
predpolagam che moje da se vikat stoinosttie na id (vsichkite)
v php i posle da se vzema nai-goliamato, no ne moga da go izmislia
v momenta...

any ideas? 10x


-
http://imot.GBG.bg - Èìîòúò, êîéòî òúðñèòå.

A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html



A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html

RE: lug-bg: MySQL query

2002-11-17 Thread Peter An. Zyumbilev 
I vse pak ste otblezha che ste ti tribvat 2 zaivavki za da nparavish tova s
mysql
skoro ne sam go pravil tova s mysql i ne moga da se setia dai mojeshe s edna
v zaivka...
v normalnite DB deto imat subselct niama problem..ako se setai ste ti kaja

Peter Angelov Zyumbilev
Web Developer & Administrator
web: http://www.bivol.net 
email: [EMAIL PROTECTED] 
tel. : + 359 88 966940



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Teodor Penev
Sent: Sunday, November 17, 2002 7:29 PM
To: [EMAIL PROTECTED]
Subject: lug-bg: MySQL query


zdrasti lug-bg,

imam slednoto pitane:
MySQL tablica s razlichni poleta -

++--+
| id  | name|
+-+-+
| 1   | joe |
+-+-+
| 2   | jane|
+-+-+
| n   | bill|
+-+-+


celta e da vzema stoinostta na nai-goliamato 'id' (n)
(ili poslednoto) i da go vkaram v php code.
neshto kato SELECT id FROM table ORDER BY id WHERE id = '...'
...
posle da uvelicha biggest id + 1 za nov zapis i t.n.
predpolagam che moje da se vikat stoinosttie na id (vsichkite)
v php i posle da se vzema nai-goliamato, no ne moga da go izmislia
v momenta...

any ideas? 10x


-
http://imot.GBG.bg - Èìîòúò, êîéòî òúðñèòå.

A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html



A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html

lug-bg: cd-burningðernet question

2002-11-17 Thread RedHead Linux User 
  Zdraveite!
 Shte byda max. kratyk:
1. Mojete li da mi prepory4ate nqkakav dobyr software
za burn-vane na cd-ta (CD-R, CD-RW...).. moje i pod
X...
2. Kak da vidq host-ovete v LAN mreja eth1 na Linux
box kym koito se log-vam ot internet 4rez ssh? 

{ eth1  Link encap:Ethernet
inet addr:10.10.0.1  Bcast:10.10.0.255 
Mask:255.255.255.0 }

 Thx

__
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com

A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html

Re: lug-bg: MySQL query

2002-11-17 Thread krasimir 
öèòèðàì  Teodor Penev <[EMAIL PROTECTED]>:

> zdrasti lug-bg,
> 
> imam slednoto pitane:
> MySQL tablica s razlichni poleta -
> 
> ++--+
> | id  | name|
> +-+-+
> | 1   | joe |
> +-+-+
> | 2   | jane|
> +-+-+
> | n   | bill|
> +-+-+
> 
> 
> celta e da vzema stoinostta na nai-goliamato 'id' (n)
> (ili poslednoto) i da go vkaram v php code.
> neshto kato SELECT id FROM table ORDER BY id WHERE id = '...'
> ...
> posle da uvelicha biggest id + 1 za nov zapis i t.n.
> predpolagam che moje da se vikat stoinosttie na id (vsichkite)
> v php i posle da se vzema nai-goliamato, no ne moga da go izmislia
> v momenta...
> 
> any ideas? 10x




 $result=mysql_query(sprintf("SELECT (MAX(tablename.id)+1) from 
table.name;") , $link);
 if($row = mysql_fetch_array($result))  {
if ($row[0]=='') $id=1; else
$id=$row[0];
 } else {
exit();
 }
mysql_query("insert into tablename values (".$id." , ...)");

ako oshte ne si promenil poleto na auto increment moje da polzvash tozi 
kod
krasimir

Êàêâî å ðåêëàìà â Èíòåðíåò? - http://reklama.mail.bg


A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html

Re: lug-bg: .dat s cyrilic(DOS) kam drug data format s cyrilic-1251

2002-11-17 Thread Damyan Ivanov 
On Fri, Nov 15, 2002 at 04:11:51PM -0800 Emil Slavov wrote:
> Attachnal sam Info454.dat . Problema mi ne e samo v kodirovkata, prosto ne 
> vigdam kak ot tozi format moga da splitna informaciata i da ia vkaram v 
> MySQL.

Ñëåä êàòî ðàçãàäàåø ñòðóêòóðàòà, ìîæåø äà èçïîëçâàø unpack çà äà
èçâëè÷àø ñòðóêòóðèðàíàòà èíôîðìàöèÿ îò ôàéëà.

`perldoc -f unpack'


äàì

-- 
Damyan Ivanov Creditreform Bulgaria
[EMAIL PROTECTED] http://www.creditreform.bg/
phone: +359 2 928 2611, 929 3993   fax: +359 2 920 0994
mobile: +359 88 566067 ICQ: 3028500


A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html