| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> your using access specific stuff, but using an odbc connection?
<0> or maybe not ...
<0> try using '&' instead of '+' ... *shrug*
<1> MoZ: Me? Naw, standard SQL.
<1> The SQL query is the same in both.
<2> Aragorn16: can you execute the sql in access?
<0> what's the error that's being reported ... ?
<1> MuteThis: Yes.
<1> Moz: No error, just returning no records.
<1> I know it works though, because it was originally part of a more complex query w/several more tables.
<1> All I did was take out the SIZES out of the complex one and it worked.
<1> So I've narrowed it down to something about the SIZES table.
<3> More than likely its some silly mistake in your VBA code and you're not p***ing the query you think you are.
<3> Misescaped quotes, whatever.
<1> I did a watch on the query.
<1> I copied the value of the query immediately before the call and pasted it into an Access SQL query.
<1> Trust me, they're the same.
<1> I've checked the field types on the joined fields; they, too, are the same.
<2> then you need vba help not sql
<1> Seems like a SQL bug though. Are you saying that because the syntax of the query looks right?
<1> (btw, 10:1 I go to #vb and they tell me "It's a SQL problem")
<2> no if the interpolated sql executes directly, the provider should be able to execute it
<3> Aragorn16: Probably. But they'd be wrong. :)
<1> heh
<2> Aragorn16: remove your where condition, do you get results?
<1> Good question..lemme see...
<3> Something isn't translating correctly through VBA. A table is a table, theres no reason why they query would work right in one environment but not the other.
<3> So, it must be some mistake with the VBA.
<1> That's pretty simple code too, but I won't discount it at this point.
<1> Dangit, Word hung on me. Query's too big for it w/out the join constraint.
<2> so you sql works
<2> try a different id
<4> moz loves microsoft
<4> and hyundai :/
<1> MuteThis: I can't wait until I gain control of my computer again... :(
<2> huh
<1> There's no way to stop dumprep.exe, is there.
<1> 'Cause it's eating up about 5k/sec.
<1> Ah! Got it!
<1> OK, let me go do that query again...
<2> someone has issues outside VBA & Sql
<1> lol..yeah, I know
<1> Oh, now that's interesting...
<1> I think it's a typecast problem.
<1> I removed the join on SIZES and EIQOSLINE and it gave me some 942-odd results.
<2> untyped scripting takes another victim
<1> Which means that the SQL is working.
<1> The problem must be in the join itself.
<4> pebkac error
<2> this = that != join
<2> imo
<1> Well, yes, I originally had it as a join.
<1> They both get the job done, I just call it that too.
<1> FROM EIQOSLINE INNER JOIN SIZES ON EIQOSLINE.size=SIZES.code
<1> There, now it's a join. :P
<5> hi.. sql 2000.. wondering .. i've made an sql statement to do a bulk insert from a file.. now i just realized the sql server and the webserver are 2 separate boxes.. my question can you do bulk insert via http:// ?
<2> not that i'm aware of
<1> OK, so let's say that it's a typing issue. How can I dynamically cast both fields to be the same thing?
<4> xloc "sql server 2000"
<5> yes sorry
<6> it would be nice if you could map a webfolder on the sql box to the web box...
<1> (I mean, they /are/ the same type, but obviously the query results say otherwise)
<4> xloc not that i know of
<2> CAST(field AS Type) for sql server
<2> for access you'll need to consult help or someone else might know
<4> you'll need to transfer the file or connect to the sql server remotely
<1> MuteThis: thx
<6> xloc: you could probably use a w32 version of wget to transfer the file to the sql box.. then load it from file
<6> but no direct way to connect to http
<5> most likely create a mapped drive on my sql 2000 box that maps to the webserver
<4> as long as you use a vpn
<5> right.. cool. thanks for your help
<4> donations at the door
<7> anyone know if ORA-00932: inconsistent datatypes <- could occur when im trying to insert a too long string into varchar2(4000) column?
<2> seems straight forward, a varchar2(4001+) != varchar2(4000)
<7> yep
<8> hrm... can I launch a function in SQL 2k by feeding an argument via a query? SELECT dbo.foo(SELECT a FROM b WHERE c = d) ?
<3> Did you try it? :)
<8> yes, or at least I'm tweaking the actual version now
<8> but I'd like to know the feasability before spending lots of time trying to make it work.
<8> got it - unnecessary issue.
<3> Does it work? I'd ***ume yes, but I dunno. Never tried it.
<3> :)
<9> anyone know why all of a sudden im getting an Invalid operATOR FOR DATA TYPE
<9> for
<9> SELECT ID, ISNULL(firstname, ' ') + ' ' + ISNULL(middlename, ' ') + ' ' + ISNULL(lastname, ' ') AS FullNames FROM tblAUTHORS
<7> maybe you need ||
<9> whats that?
<7> try if 'foo' + 'bar' works
<9> instead of +
<9> ok
<4> isnull(firstname || ' ','') || isnull(middlename || ' ', '') || isnull(lastname, '') as FullNames
<10> ok i know this isn't exactly an SQL questin... but i figured i could find some ACCESS users here... i inserted a image into a form in access... now i watn to resize it without losing the proportion of the image... like in adobe when your resize something it looks the same as it does big or small....
<9> yeah but that only gives me the firstnamelastname
<9> to the value of the table
<4> try what i said Gm0nEy
<4> also state your sql rdbms AS THE RULES FOR THE CHANNEL STATE
<9> sorry
<8> ALSO, DANCE ON ONE FOOT WHILE WEARING A SKIRT OF PASTA.
<4> quiet
<4> today isn't pasta day
<8> sorry. Can't stand rule-benders. It's not Tortellini Tuesday?
<9> so i get incorrect syntax near '|'
<4> gmo
<4> either you're an idiot, or i missed where you stated your rdbms
<4> that the rules tell you to do, and i asked you to do
<11> anyone know if there is a dos command to get the system directory of the current windows box
<8> %system% ?
<8> nope
<11> echo %system%?
<9> nm thanks i got it
<11> %windir% is what i needed, thanks
<4> cd
<8> aha
<4> gets cur dir
<4> also if you are wondering
<11> i needed the system dir
<4> k
<7> hey anyone remember that set page or smth in sqlplus that turned off printing the column names after a certain number of rows?
<12> Hi guys, could you pls try to help me? - http://sql-servers.com/nopaste/?show=214
<4> if you have null values don't use inner join then
<4> learn the different join types
<4> and the truth tables or outputs
<4> for all given inputs
<12> I try to replace last 2 joins with left outer joins
<12> and get an error
<13> no where ...
<4> my first statement is
<4> organize your sql statement into a structure that is easy to read
<12> what you mean?
<12> it's standart access query
<4> i mean
<4> have structure in your code
<4> format it
<3> If you can't take the time to structure your query, I can't take the time to try to read it.
<12> I don't understand what u want from me. Maybe it's cuz english is not my native language..
<12> what does "structure your query" mean ?
<4> let's work through your logic first
<12> ok
<4> do you want to include parts where there is no customer
<4> that matches
<9> If I have a SP INSERT ... into a table that has an idenity column and then I SET @authid= SCOPE_IDENTITY() i get an exception stating that expects parameter '@authid
<9> and do another INSERT with @authid
<12> no
<12> customer always presents for every parts
<4> do you want to include parts where there is no supinvoices id
<12> if there is no supinvocesid so I will not be able to find CustPercents.Perc
<12> and in this case
<4> yes or no
Return to
#sql
or
Go to some related
logs:
500 OOPS: bad bool value in config file for: ssl_enable
#beginner
ati-driver-install 8.22
torrent site for horror movies
#worldcup
Incorrect syntax near 'auto_increment'
#beginner
Magdline cults
acrinoms
#beginner
|
|