[es] - Problem sa date between

pl4stik
Senior .NET programmer/Consultant
oDesk
NI na nebu NI na zemlji

Član broj: 173596
Poruke: 715
*.dynamic.isp.telekom.rs.

Sajt: xx-auth.com.azhar.arvixe...

+31 Profil

Problem sa date between

^{18.01.2013. u 13:26 - pre 136 meseci}

Napravio sam upit koji vraca ako neki column sadrzi parametar ili je null ali ne mogu da dodama i vreme.. tj. izmedju datuma

Code:

SELECT        ID, Title, keyword, jobtype, DateCreated, location
FROM            Test
WHERE        (@Title IS NULL) OR
                         (Title LIKE '%' + @Title + '%') AND (@keyword IS NULL) OR
                         (keyword LIKE '%' + @keyword + '%') AND (@jobtype IS NULL) OR
                         (jobtype LIKE '%' + @jobtype + '%') AND (@location IS NULL) OR
                         (location LIKE '%' + @location + '%') AND (DateCreated BETWEEN '1/10/2013' AND '1/12/2013')

Jel vidi neko sta je problem?

To sto nekoliko miliona ljudi tvrdi da nisi u pravu ne znaci da stvarno nisi - Frank Zappa

https://youtu.be/DLe358DPGXU

Odgovor na temu

plague
Software Developer
Auckland, NZ

Član broj: 46734
Poruke: 623
*.dynamic.isp.telekom.rs.

+373 Profil

Re: Problem sa date between

^{18.01.2013. u 13:37 - pre 136 meseci}

Gotovo sam siguran da Datum mora biti u formatu "yyyy-mm-dd", a pritom nisam siguran da li moras da castujes DateCreated u date u slucaju da je tipa datetime.

Odgovor na temu

pl4stik
Senior .NET programmer/Consultant
oDesk
NI na nebu NI na zemlji

Član broj: 173596
Poruke: 715
*.dynamic.isp.telekom.rs.

Sajt: xx-auth.com.azhar.arvixe...

+31 Profil

Re: Problem sa date between

^{18.01.2013. u 13:47 - pre 136 meseci}

Kad osttavim samo

Code:
DateCreated BETWEEN '1/10/2013' AND '1/12/2013'

radi OK...

To sto nekoliko miliona ljudi tvrdi da nisi u pravu ne znaci da stvarno nisi - Frank Zappa

https://youtu.be/DLe358DPGXU

Odgovor na temu

plague
Software Developer
Auckland, NZ

Član broj: 46734
Poruke: 623
*.dynamic.isp.telekom.rs.

+373 Profil

Re: Problem sa date between

^{18.01.2013. u 13:59 - pre 136 meseci}

Jesi li siguran da ti ostatak upita vraca neki rezultat kada izbacis proveru datuma? Kako si originalno zakljucio da je datum problem?

Bez zagrada operator AND ima prednost i prvi ce se izvrsiti.

Odgovor na temu

pl4stik
Senior .NET programmer/Consultant
oDesk
NI na nebu NI na zemlji

Član broj: 173596
Poruke: 715
*.dynamic.isp.telekom.rs.

Sajt: xx-auth.com.azhar.arvixe...

+31 Profil

Re: Problem sa date between

^{18.01.2013. u 14:03 - pre 136 meseci}

OD jutros u 5 sam poceo da se igram proverio sam sve i problem je da rade zajedno
Ovo radi OK

Code:
SELECT        ID, Title, keyword, jobtype, DateCreated, location
FROM            Test
WHERE        (@Title IS NULL) OR
                         (Title LIKE '%' + @Title + '%') AND (@keyword IS NULL) OR
                         (keyword LIKE '%' + @keyword + '%') AND (@jobtype IS NULL) OR
                         (jobtype LIKE '%' + @jobtype + '%') AND (@location IS NULL) OR
                         (location LIKE '%' + @location + '%')

Ovo radi OK

Code:
SELECT        ID, Title, keyword, jobtype, DateCreated, location
FROM            Test
WHERE        (DateCreated BETWEEN '1/10/2013' AND '1/12/2013')

Ovo ne radi OK, vraca sve

Code:
SELECT        ID, Title, keyword, jobtype, DateCreated, location
FROM            Test
WHERE        (@Title IS NULL) OR
                         (Title LIKE '%' + @Title + '%') AND (@keyword IS NULL) OR
                         (keyword LIKE '%' + @keyword + '%') AND (@jobtype IS NULL) OR
                         (jobtype LIKE '%' + @jobtype + '%') AND (@location IS NULL) OR
                         (location LIKE '%' + @location + '%') AND (DateCreated BETWEEN '1/10/2013' AND '1/12/2013')

To sto nekoliko miliona ljudi tvrdi da nisi u pravu ne znaci da stvarno nisi - Frank Zappa

https://youtu.be/DLe358DPGXU

Odgovor na temu

plague
Software Developer
Auckland, NZ

Član broj: 46734
Poruke: 623
*.dynamic.isp.telekom.rs.

+373 Profil

Re: Problem sa date between

^{18.01.2013. u 14:09 - pre 136 meseci}

Udari zagradu tako da bude:

Code:

SELECT        ID, Title, keyword, jobtype, DateCreated, location
FROM            Test
WHERE        ((@Title IS NULL) OR
                         (Title LIKE '%' + @Title + '%') AND (@keyword IS NULL) OR
                         (keyword LIKE '%' + @keyword + '%') AND (@jobtype IS NULL) OR
                         (jobtype LIKE '%' + @jobtype + '%') AND (@location IS NULL) OR
                         (location LIKE '%' + @location + '%'))
                         AND (DateCreated BETWEEN '1/10/2013' AND '1/12/2013')

Odgovor na temu

pl4stik
Senior .NET programmer/Consultant
oDesk
NI na nebu NI na zemlji

Član broj: 173596
Poruke: 715
*.dynamic.isp.telekom.rs.

Sajt: xx-auth.com.azhar.arvixe...

+31 Profil

Re: Problem sa date between

^{18.01.2013. u 15:12 - pre 136 meseci}

Ala si ih udarioooooo... Hvala, hvala, hvala, hvala ... Care, ako ikad dolazis u Nis rado bi ti pokazao jednu dobru kavanu...

To sto nekoliko miliona ljudi tvrdi da nisi u pravu ne znaci da stvarno nisi - Frank Zappa

https://youtu.be/DLe358DPGXU

Odgovor na temu

dragancesu
subotica

Član broj: 38340
Poruke: 2189
*.adsl.eunet.rs.

+73 Profil

Re: Problem sa date between

^{19.01.2013. u 22:50 - pre 136 meseci}

Ima nekoliko upita slicnih kao

Code:
(@Title IS NULL) OR (Title LIKE '%' + @Title + '%')

Imam osecaj da je problem u parametru, verovatno imas neku formu gde unosis te parametre, i tamo ako ne upises nista je prazan string sto je razlicito od NULL

Mozda je bolje da generises upit na osnovu unosa, prakticno u WHERE da budu samo oni koje si uneo.

Pomozite Micro$oftu u borbi protiv piraterije, poklonite prijatelju Linux

Odgovor na temu

pl4stik
Senior .NET programmer/Consultant
oDesk
NI na nebu NI na zemlji

Član broj: 173596
Poruke: 715
*.dynamic.isp.telekom.rs.

Sajt: xx-auth.com.azhar.arvixe...

+31 Profil

Re: Problem sa date between

^{19.01.2013. u 23:18 - pre 136 meseci}

Radi bas kako treba, a i kad sam ga pravio bas sam trazio nacin da ne pravim/generisem upit u codu....

To sto nekoliko miliona ljudi tvrdi da nisi u pravu ne znaci da stvarno nisi - Frank Zappa

https://youtu.be/DLe358DPGXU

Odgovor na temu