MS Access 2000 kai SQL BOH8EIA!!!!!!!!!

[kavaliotis]

Paides exo to ekshs provlima..Kano project kai telos panton exo ftiaksei mia selida pou exei mia forma pou prepei na sumplhrwsei o xrhsths..Na valei onoma, email, na tsekarei kapoia koutakia analoga me to ti protima, na dialeksei apo drop-down menus ktl.. Auta prepei na swzontaia automata se database kai to susthma na ta epeksergazetai kai na vriskei "matches" an uparxoun (px an taksidevoun 2 atoma thn idia mera kai thn idia wra) na stelnete automata email se autous kai na tous to leei..<P>1on)Pos swzw auta pou vazei o xrhsths sthn forma mesa sthn database?<BR>2on)pos to kano na psaxnei mesa sthn database (exo ftiaksei mia me ena mono table)<BR>3on)pos vriskei ta matches se epilegmena mono kommatia ths database kai pos stelnei email pisw?<P>To kserw oti zhtao polla aplws opoiadhpote boh8eia dekth..Apo SQL den exw gnwsh, ASP ma8aino apo to Dreamweaver UltraDEV 4 pou doulevo kai Access ksero kapoia pragmata, px pos na sundeo ta tables ktl..Aplos den ksero pos na kano thn ergasia, giati mallon 8a prepei na ftiakso kai allo table kai kapos na psaxnei to susthma mesa se auta na vriskei idia stoixeia..San primary key exo to username tou xrhsth (kanei login se mia selida prin)..

[onLINEr]

1) yparxoune polloi tropoi na soseis stoixeia pou lamvaneis apo mia forma.. ASP den gnorizo kala. Xero na sou proteino enan tropo alla proypothetei JAVA. Xereis java?<P>2) stin database tha psaxeis stelnontas ena SQL query (tora to pos tha to steileis exartatai apo to pos tha kaneis implement to storage kai to retrieval)<P>Esto loipon oti to table legetai Tbl, to sql query px gia na vreis poioi taideyoun tin idia mera exei tin morfi:<P>SELECT name FROM Tbl WHERE Date = '12/13/01';<P>ayto sou vriskei ta onomata aytonon pou taxideyoune stis 12/13/01<P>3) gia na stileis email boreis kai pali me pollous tropous.. paradeigma to JAVA application pou tha psaxnei to Database tha kanei ayti ti douleia i akoma boreis na tou peis na trexei ena VBScript pou tha ta stelnei meso tou outlook sou.. <P>ayta boro na skefto....<P><BR>_____________________________________<P><IMG SRC="http://privatewww.essex.ac.uk/~idimit/img/itnet_small.gif" border=0><BR>> <A HREF="http://itnet.gr" TARGET=_blank>itnet.gr</A> <<BR><p>[This message has been edited by onLINEr (edited 21-05-2001).]

[kavaliotis]

Koita kala osa les kai isos kai einai kai olososta, alla pos stelneis ena SQL query? Kai pou ton vazo ton kodika pou mou edwses? Eimai arxarios katalaves? An mporeis me apla bhmata na mou peis ti na kanw 8a me boh8ouses afantasta..Xrhsimopoiw Macromedia DreamWeaver UltraDEV 4 kai exo kanei tis selides se ASP..Exo ftiaksei database se MS Access 2000..

[onLINEr]

koita...<P>to thema einai oti ola ayta pou zitas, me JAVA ta exo kanei kai xero poly kala pos ginontai, de mou pes omos tipota ara tha ypotheso oti den gnorizeis programmatismo se java. Tora me Active Server Pages exo asxolithei poly ligo gia na po oti eimai se thesi na se voithiso.<P>ayto pados pou pas na kaneis den einai poly eykolo. An thes bes sto kanali tou insomnia sto chat.groovy.gr na to sizitisoume real time gia na do ti akrivos thes...<P>sorry pou den boro na sou proteino kati allo.. isos kapoios allos insomniac na borei!<P>ta leme <BR>_____________________________________<P><IMG SRC="http://privatewww.essex.ac.uk/~idimit/img/itnet_small.gif" border=0><BR>> <A HREF="http://itnet.gr" TARGET=_blank>itnet.gr</A>

[apoc]

Den kserw alla kati paromoio ekana me ton sindiasmo VB kai access...vevaia den htan web based appilcation opote se ekeino to kommati den mporw na exw apopsh..pantos sigoura me thn VB den thelei kai toso poli douleia oso mporei na thelei me thn Java....<P><P>------------------<BR>What is the Matrix?

[kavaliotis]

Wpa file esena 8elo! Kai ego auto pou kano einai me ASP alla xrhsimopoiei VBScript..An mporeis na mou peis parapano gia auto pou zhtao!!!!

[apoc]

Loipon gia na eimai eilikrinhs den eimai o pio experienced user se VB isws o Onliner na mas voithisei pio poli...<BR>Profanws ama dialekseis na to kaneis me VB tha prepei sthn selida sou na vales VB script.<BR>To pos tha geinei h allhloepidrash ths efarmoghs apo thn selida sto programa kai to antitheto den kserw.. kapoios pio empeiros mporei na mas diafwtisei...<P>to pragmatiko functionality omws autou pou zhtas ginetai sxetika eukola se mia efarmogh VB<BR>fiaxneis prosextika mia aplh database me enan pinaka h kai perisoterous analoga me tis anagkes sou gia ta stoixeia tous xrhsth, sthn periptwsh sou mporei na einai kai enas monos pinakas pou na exeis ta stoixeia tou xrhsth....ola auta eukola me thn access<P>meta sto interface pou exeis...ola ta stoixeia pou dialegei o xrhsths apla me liges aples grammes kwdika ta pernas san ena neo record mesa ston pinaka tou database pou exeis fiaksei.<P>H database sou arxizei kai gemizei me records pou meta esi mporeis na ta epeksergasteis opws theleis mesa apo to VB application eite kanwntas merika querries sthn access ..pou einai pio filiko apo to na grafeis pure sql eite grafwntas esi o idios twn kwdika gia ta quirries mesa apo to VB application.<BR>Egw tha to evriksa pio eukolo na ekana ta querries sthn access kai meta na ekana import sthn VB opote to thema ths anazhthseis stoixeiwn ktl ktl anagetai se kati pio eukolo ,thn anazhthsh tou swstou querry ...<P>ola auta pou sou lew einai sxetika genikothtes gia twra...exw ena mikro keno sto thema ths allhlepridrashs selidas kai vb application...pantos <BR>an hmoun sthn thesi sou tha prospathousa na vrw thn lisi mesa apo ta etoima paketa idiaitera otan oi gnwseis peri developing einai psilo periorismenes..<BR>opws sou eixa grapsei pio palia ena filos tetartoeths persi paredwse ena online shop site san ptixiakh xwris na exei grapsei oute mia grammh kwdika sthn zwh tou.xrhsimopoiwntas drumbeat 2000 ecomerce edition..<BR>h epomenh mou lisi tha htan na xrhsimopoihsw thn Visual Basic kai oxi Java giati to thema meta anagetai se kalh gnwsh toulaxiston twn vasikw stoixeiwn afths ths glwssa kati pou nomizw oti den sou menei kairos na kaneis...<P>To allo sigouro einai oti genika mesa apo merika post den mporeis na vgaleis akrh dhladh to erwthma pou theteis peri primary key..einai sxetiko ennow..oti mporeis na pareis analoges apanthseis sxetika me to ti thes na kaneis...<BR>pantos etsi opws mporw na kseftw egw pos mporei na geinei den mporw na vrw logo na kaneis kai allo table .Me thn Vb poli apla mporeis na psaxneis ton existing table kai na vriskeis ta mattches pou thes kai malista ola auta me thn voithia twn querries apo thn access....<BR>Genika to thema thelei shzhthsh poli kai polles apopseis tha pesoun...elpizw kai isws pio empeiroi apo mena na katathesoun apopseis kai liseis etsi wste na mporesoume na se vouthisoume<P>pantos eilikrina....egw file otan to eida den to pisteua oti to eixe kanei mono me ena etoimo paketo..kai malista xwris na kserei programatismo...<P><P>------------------<BR>What is the Matrix?

[kavaliotis]

Se euxaristw gia thn boh8eia alla den katalava kai pali pos na doulepso..Mhn to les, mexri tora apo posts tetoia kai apo to help tou programmatos exo kanei oti exo kanei xoris na ksero gri programmatismo..Den exo katalavei omws pos ta stoixiea mias formas pou sumplhrwnei o xrhsths 8a swzontai sthn database pou exo ftiaksei..Pos 8a linkarontai metaksu tous? Kai to amesws epomeno einai pos 8a psaxnei automata to susthma gia matches mesa sthn access kai na stelnei to apotelesma (an vrei) me email analoga me ta apotelesmata ths formas se merika mono paidia (oxi px analoga me to onoma tou xrhsth as poume!!!)..

[apoc]

STO INTERACTION METAKSI THS FORMAS KAI TOU DATABASE EKEI EINAI POU DEN EXW SAFH APOPSH...ISWS KAPIO SCIPT SE VB POU THA KALOUSE MIA ALLH EFARMOGH SE VB H ...AKOMA KAI MONO ENA SCRIPT NA MPOREI NA KANEI THN METAFORA DEDOMENWN APO THN SELIDA STHN DATABASE...EDW PREPEI NA MAS PEI KAPOIOS POU EXEI APOPSH...<BR>TWRA STO NA PSAXNEIS THN DATABASE APLA PREPEI NA SKEFTEIS POS THA GRAPSEIS TO SWSTO QUERRY STHN ACCESS....<BR>DHLADH NA KANEIS ENA QUERRY POU THA TOU LES<BR>NA PSAXNEI TO FIELD ME TON PROORISMO KAI TO FIELD ME TO ONOMA KAI NA VRIKSEI DUPLICATES H KATI TETOIO...EINAI THEMA DHLADH QUERRIES STO NA VREIS TO APOTELESMA....<BR>TO POS THA STELNEIS MAIL <BR>PALI THA PREPEI NA GINEI ME KAPIOO VB SCRIPT<BR>OPOU THA PAIRNEI TO MAIL APO TO FIELD TOU PINAKA KAI THA KANEI EKKINHSH TO OUTLOOK<BR>....<BR><P>------------------<BR>What is the Matrix?

[onLINEr]

loipon paides:<P>fadasteite enan web server pou trexei tin selida tou kavalioti. Fortonei i en logo selida me oles tis epiloges kai paei o user kai dialegei analoga me tin protimisi tou grafontas onomata kai ta loipa.<P>Ean milame gia apli efarmogi, pou sti prokeimeni apli pame na bgaloume, o idios o server exei ston disko tou ektos apo tis selides tou site, to arxeio .mdb koinos tin database.<P>Ayti i database einai gia paradeigma sto path c:\my documents\projects\kavaliotis\databases\ kai legetai MiaApliDatabase.mdb<P>emeis ayto pou theloume kathe fora pou o xristis pataei submit einai na vriskei ayti tin database mesa se ayto to path kai na tis stelnei <I>me KAPOION tropo</I> to SQL query.<P>pos omos?<P>Yparxei ena ...as to poume interface pou onomazetai ODBC. Ayto epitrepei applications exoterika tis Database na epikoinonisoune me aytin xrismopoiontas tin koini pleon glossa SQL.<P>oloi tha exete dei to ODBC connections sto control panel. <P>ekei pera an paei kapoios kai kanei ADD kai dialexei .mdb type file sto menu pou tha tou emfanistei tha boresei tin database pou itane piso apo OLO ayto to makrinari path, na tin onomasei kapos (sto Description field: as poume oti tin onomazeis KAVALIOTIS) kai apo ekei kai pera otan sto application les vres mou to database KAVALIOTIS kai kantou queries, updates kai deletes ayto paei meso ODBC kai to odbc mono tou to stelnei sto sigkekrimeno arxeio ston disko xoris esena na se noiaxei! tha borouse to database KAVALIOTIS na itane se allo pc kai meso network na pigenei kai na to kanei access. Esena PALI den se noiaxei opos eipa giati esy KAVALIOTIS tin les eite einai local eite networked.<P>apo kei kai pera i kathe glossa exei ta dika tis.. gia paradeigma i JAVA pou xero ego exei to JDBC to ODBC interface driver to opoio metafrazei an thes ta commands pou stelneis apo ena java application se katanoita sto ODBC commands.<P>otan kaneis loipon to query sou, i SQL sou gyrnaei ena table piso PALI MESO ODBC to opoio afinei ola ta axrista stoixeia px dieythinseis klp kai sou gyrnaei ta stoixeia pou zitas. Meso pali tis glossas pou xrismopoieis ANEXERAITOS, boreis na laveis ayta ta apotelesmata kai na ta kaneis oti thes.<P>elpizo na katalavate kati apo ayta giati den eimai o kaliteros sto na exigo.....<P> <P>_____________________________________<P><IMG SRC="http://privatewww.essex.ac.uk/~idimit/img/itnet_small.gif" border=0><BR>> <A HREF="http://itnet.gr" TARGET=_blank>itnet.gr</A> <

[Acrobat]

Kavalioti><BR>Twra eida to topic kai giauto arghsa na mpw sto "kolpo".<P>Mias kai doulebeis me Ultra Dev tha sta pw etsi gia auto:<P>afou ftiakseis to recordset,pas sto "server behaviours" kai dialegeis to "insert record".<BR>Apo ekei kai istera milame gia wizard pou tha sto kanei sxedon mono tou.<P>gia to na psaxnei pou les hgaine sto hel tou ultradev kai psakse gia "search page" kai tha sta bgalei ola (panta pasaxnoume to help!!)<BR>gia to 3o pou rwtas den kserw na sou pw...as sou pei kapios allos.<BR>An den katalabes kati..pes to.<P>------------------<BR><P><AcRoBaT>

[Acrobat]

<BLOCKQUOTE><font size="1" face="Verdana, Arial">quote:</font><HR>Originally posted by kavaliotis:<BR><B>Wpa file esena 8elo! Kai ego auto pou kano einai me ASP alla xrhsimopoiei VBScript..An mporeis na mou peis parapano gia auto pou zhtao!!!!</B><HR></BLOCKQUOTE><BR>kai auto ti einai pali?<BR>i asp einai server scripting glwssa kai xrhsimopoiei VB...ti perimenes?<P><P>------------------<BR><P><AcRoBaT>

[Acrobat]

<A HREF="http://download.macromedia.com/pub/ultradev/updates/win/ud401up.exe" TARGET=_blank>http://download.macromedia.com/pub/ultradev/updates/win/ud401up.exe</A> <P>einai ena update tis macromedia gia to ultra dev kai to dreamweaver...<P>------------------<BR><P><AcRoBaT>

[kavaliotis]

File onLINEr ta exo kanei auta me to ODBC pou les..Eixa paei sto System DSN kai sto User DSN kai eixa kanei ekei ADD gia MS ACCESS kai eixa valei na psaxnei thn database pou exo ftiaksei..Apo ekei kai pera auto pou den exo kanei einai auto pou leei o filos Actobat, dhladh na ftiakso ta recordset giati den exo katalavei ti einai oso kai an diavaza to help kai epsaxna kai sto net..Apo oti katalava einai eukolo pragma, apla exei kollhsei to mualo mou gamwto! Ama katalavo auta isos katalabo kai pos na kano to SQL Query..Oso gia to email pou 8a stelnetai meta, den 8elw na anoigei to outlook opws eipe kapoios alla automata to susthma na stelnei email stous tuxon xrhstes me koina pragmata sthn database..<P>Brhka ena paidi edw pou kserei SQL kai ACCESS kai 8a me boh8hsei shmera to apogeuma opote 8a sas pw argotera ama exw kanei kammia proodo kai an lu8hkan ta problhmata mou...Pantos me vlepw pali na rwtaw! <IMG SRC="http://www.insomnia.gr/cpubb/smilies/cwm30.gif" border=0> <IMG SRC="http://www.insomnia.gr/cpubb/smilies/cwm16.gif" border=0>

[kavaliotis]

Milame 8a to spasw to PC gamwto! Exw kataspastei giati tipota den mou doulevei..Prwta apo ola,pao na kano preview in browser tis selides pou exo kanei kai fortonei ton browser alla leei oti "The page cannot be displayed"..Exw valei kanonika ta panta sto ODBC kai epishs sta CONNECTIONS mesa sto Dreamweaver ta exo valei ola kanonika kai prospa8ei na sunde8ei sto LOCALHOST alla tipota..Eimai sigouros oti ta exo valei swsta giati ta exo tsekarei kai me ena site pou deixnei me screenshots pos to setareis..Opote den mporo kan na tis dw,poso mallon na pathsw to login gia na dw an fortonei thn epomenh selida pou exei thn forma..<BR>Epishs den mporw me tipota na sundesw thn database pou exo kanei me thn forma pou exo ftiaksei me to Dreamweaver..H ACCESS exei ena import feature,alla doulevei mono me HTML selides...Telos panton thn ekana save as HTML alla kai pali olo errors mou ebgaze.. Ama thn eixa kanei apo ACCESS mesa thn forma exei automata na ta swzei sthn database..Apo to dreamweaver omws pos to kano?<BR>Oso gia to SQL Query,ekana ena mesa sthn Access alla kai pali den kserw pos 8a trexei kai 8a psaxnei automata..Skata kai aurio exw parousiash kai den mou doulevei tipota