Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Can i use database alias with dataasist?

Can i use database alias with dataasist?

Thread began 4/19/2010 5:17 pm by aaron5263 | Last modified 4/22/2010 6:27 am by Jason Byrnes | 1080 views | 5 replies |

4/19/2010 5:17 pm | #1 aaron5263

Can i use database alias with dataasist?

will dataassist 2.0.6 recognize database alias names? It seems like it does not recognize them.

4/20/2010 6:46 am | #2 Jason ByrnesWebAssist

No, it will not recognize alias names, only the original names that are assigned in the table.

4/21/2010 11:58 am | #3 aaron5263

ok how do i get around this problem because im getting an error saying
Ambiguous column name. i have several tables joined together via left joins.
i made the mistake of naming column names the same in 2 tables.

4/21/2010 12:29 pm | #4 Jason ByrnesWebAssist

in the code that references the column name, you need to add the table name.

Send a copy of your page and I will show an example of what needs to be changed.

4/21/2010 4:07 pm | #5 aaron5263

like this ?

'comparison list additions
WADbSearch1_whereClause=BuildFilterString("products.master_cat","" & cStr( Request.QueryString("gauges") ) & "","","=",0,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
WADbSearch1_whereClause=BuildFilterString("products.catagory","" & cStr( Request.QueryString("auto") ) & "","AND","=",0,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
WADbSearch1_whereClause=BuildFilterString("products.sub_cat","" & cStr( Request.QueryString("gauge_size") ) & "","AND","=",0,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
WADbSearch1_whereClause=BuildFilterString("products.sub_cat_2","" & cStr( Request.QueryString("gauge_type") ) & "","AND","=",0,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)

my table is products so i added this to the query and it seems to work. Anywhere else i need to change it? would be nice if next release 2.0.7 just included the table name in front of the query section of code.

4/22/2010 6:27 am | #6 Jason ByrnesWebAssist

that should be all that needs to change.

I will add a feature request.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.