-=(ASP-Support-Group)=- Long lines

Thread: -=(ASP-Support-Group)=- Long lines

Search this list only Search all lists
-=(ASP-Support-Group)=- Long lines
Turkey	2007-02-14 09:28:17
I have a SQL query in my ASP page, but this query is too long, about 62 character in a row). I need: * offers to contract it * how can I divide it into lines ( The (_) not run ) * I want to add this expression to this query. But I want to add a (%) at the end of the parameters. Where should I add? ......AND (URUN_KODU='"&turkodu1&"' OR URUN_KODU='"&turkodu2&"').... The query that I mentioned above: SQLStr="SELECT URUN_KODU, SUM(PRG_URETIM) AS URETIM_PROGRAMI, SUM(URETIM_MIKTAR) AS FIILI_URETIM, SUM(DISSATIS) AS DIS_SATIS, SUM(ICSATIS) AS IC_SATIS, SUM(ISLICITUK) AS ISLETME_ICI_TUKETIM, SUM(DIGISLTUK) AS DIGER_ISLETME_TUKETIM FROM PAZ_URETIM WHERE ((TARIH BETWEEN '"&baslangictarihi&"' AND '"&bitistarihi&"') AND (URETICI_BIRIMKODU='"&isletmeadi1&"' OR URETICI_BIRIMKODU='"&isletmeadi2&"' OR URETICI_BIRIMKODU='"&isletmeadi3&"' OR URETICI_BIRIMKODU='"&isletmeadi4&"' OR URETICI_BIRIMKODU='"&isletmeadi5&"' ) AND (NOT (URETICI_BIRIMKODU = 'aaa'))) GROUP BY URUN_KODU, URETICI_BIRIMKODU ORDER BY URETICI_BIRIMKODU" Group homepage is here: http: //groups.yahoo.com/group/ASP-Support-Group To unsubscribe from this group, send an email to: ASP-Support-Group-unsubscribe@yahoogroups.com and cross your fingers because Yahoo is 5h1te. Yahoo! Groups Links <> To visit your group on the web, go to: http ://groups.yahoo.com/group/ASP-Support-Group/ <> Your email settings: Individual Email \| Traditional <> To change settings online go to: http://groups.yahoo.com/group/ASP-Support-Group/join (Yahoo! ID required) <> To change settings via email: mailto:ASP-Support-Group-digest@yahoogroups.com mailto:ASP-Support-Group-fullfeatured@yahoogroups.com <> To unsubscribe from this group, send an email to: ASP-Support-Group-unsubscribe@yahoogroups.com <> Your use of Yahoo! Groups is subject to: http://docs.yahoo.c om/info/terms/

Re: -=(ASP-Support-Group)=- Long lines
United States	2007-02-14 23:40:09

hi *Ali Göksel* i hope this will help you to solve the problem Best Regards strCmd += "Select EmployeeID, LastName, FirstName, Title, BirthDate, "; strCmd += "Address, City, Region, PostalCode, Country, HomePhone "; strCmd += "From Employees "; strCmd += "where Country='" + scity + "'"; *Ali Göksel <agokseletimaden.gov.tr>* wrote: I have a SQL query in my ASP page, but this query is too long, about 62 character in a row). I need: * offers to contract it * how can I divide it into lines ( The (_) not run ) * I want to add this expression to this query. But I want to add a (%) at the end of the parameters. Where should I add? ......AND (URUN_KODU='"&turkodu1&"' OR URUN_KODU='"&turkodu2&"').... The query that I mentioned above: SQLStr="SELECT URUN_KODU, SUM(PRG_URETIM) AS URETIM_PROGRAMI, SUM(URETIM_MIKTAR) AS FIILI_URETIM, SUM(DISSATIS) AS DIS_SATIS, SUM(ICSATIS) AS IC_SATIS, SUM(ISLICITUK) AS ISLETME_ICI_TUKETIM, SUM(DIGISLTUK) AS DIGER_ISLETME_TUKETIM FROM PAZ_URETIM WHERE ((TARIH BETWEEN '"&baslangictarihi&"' AND '"&bitistarihi&"') AND (URETICI_BIRIMKODU='"&isletmeadi1&"' OR URETICI_BIRIMKODU='"&isletmeadi2&"' OR URETICI_BIRIMKODU='"&isletmeadi3&"' OR URETICI_BIRIMKODU='"&isletmeadi4&"' OR URETICI_BIRIMKODU='"&isletmeadi5&"' ) AND (NOT (URETICI_BIRIMKODU = 'aaa'))) GROUP BY URUN_KODU, URETICI_BIRIMKODU ORDER BY URETICI_BIRIMKODU" Group homepage is here: http://groups.yahoo.com/group/ASP- Support-Group To unsubscribe from this group, send an email to: ASP-Support-Group-unsubscribeyahoogroups.com and cross your fingers because Yahoo is 5h1te. Yahoo! Groups Links <;> To visit your group on the web, go to: http://groups.yahoo.com/group/ASP-Support-Group/ <>; Your email settings: Individual Email \| Traditional <>; To change settings online go to: http://groups.yahoo.com/group/ASP-Support-Group/join (Yahoo! ID required) <> To change settings via email: mailto:ASP-Support-Group-digestyahoogroups.com mailto:ASP-Support-Group-fullfeaturedyahoogroups.com <;> To unsubscribe from this group, send an email to: ASP-Support-Group-unsubscribeyahoogroups.com <;> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. __._,_.___ Messages in this topic (5) Reply (via web post) \| Start a new topic . __,_._,___
Re: -=(ASP-Support-Group)=- Long lines
Australia	2007-02-15 04:16:41
The _ works fine, but you need to do it outside quoted strings. E.g. SQL = "The quick " & _ "brown fox" Regards, Dave S ----- Original Message ----- From: "Ali Göksel" <agokseletimaden.gov.tr> To: <ASP-Support-Group@yahoogroups.com> Sent: Thursday, February 15, 2007 2:28 AM Subject: -=(ASP-Support-Group)=- Long lines >I have a SQL query in my ASP page, but this query is too long, about 62 > character in a row). I need: > > * offers to contract it > * how can I divide it into lines ( The (_) not run ) > * I want to add this expression to this query. But I want to add a (%) at > the end of the parameters. Where should I add? > ......AND (URUN_KODU='"&turkodu1&"' OR URUN_KODU='"&turkodu2&"').... > > > The query that I mentioned above: > > SQLStr="SELECT URUN_KODU, SUM(PRG_URETIM) AS URETIM_PROGRAMI, > SUM(URETIM_MIKTAR) AS FIILI_URETIM, SUM(DISSATIS) AS DIS_SATIS, > SUM(ICSATIS) > AS IC_SATIS, SUM(ISLICITUK) AS ISLETME_ICI_TUKETIM, SUM(DIGISLTUK) AS > DIGER_ISLETME_TUKETIM FROM PAZ_URETIM WHERE ((TARIH BETWEEN > '"&baslangictarihi&"' AND '"&bitistarihi&"') AND > (URETICI_BIRIMKODU='"&isletmeadi1&"' OR > URETICI_BIRIMKODU='"&isletmeadi2&"' > OR URETICI_BIRIMKODU='"&isletmeadi3&"' OR > URETICI_BIRIMKODU='"&isletmeadi4&"' OR > URETICI_BIRIMKODU='"&isletmeadi5&"' > ) AND (NOT (URETICI_BIRIMKODU = 'aaa'))) GROUP BY URUN_KODU, > URETICI_BIRIMKODU ORDER BY URETICI_BIRIMKODU" > > > > > > > Group homepage is here: > http: //groups.yahoo.com/group/ASP-Support-Group > > To unsubscribe from this group, send an email to: > ASP-Support-Group-unsubscribe@yahoogroups.com and cross your fingers > because Yahoo is 5h1te. > > Yahoo! Groups Links > > > > Group homepage is here: http: //groups.yahoo.com/group/ASP-Support-Group To unsubscribe from this group, send an email to: ASP-Support-Group-unsubscribe@yahoogroups.com and cross your fingers because Yahoo is 5h1te. Yahoo! Groups Links <> To visit your group on the web, go to: http ://groups.yahoo.com/group/ASP-Support-Group/ <> Your email settings: Individual Email \| Traditional <> To change settings online go to: http://groups.yahoo.com/group/ASP-Support-Group/join (Yahoo! ID required) <> To change settings via email: mailto:ASP-Support-Group-digest@yahoogroups.com mailto:ASP-Support-Group-fullfeatured@yahoogroups.com <> To unsubscribe from this group, send an email to: ASP-Support-Group-unsubscribe@yahoogroups.com <> Your use of Yahoo! Groups is subject to: http://docs.yahoo.c om/info/terms/

[1-3]

about | contact Other archives ( Real Estate discussion Medical topics )