Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. amberdextrous

    ASP.NET + FileMaker, HTTP GET and POST problems

    Nevermind, I figured out how to perform the POST. :) The problem was with the URI. I did not have it formatted correctly...I didn't know the URI can only contain up to the question mark, and everything else must be contained in the POST body. I also found that even though my FM database has...
  2. amberdextrous

    FileMaker + VB.NET, GET/POST, XML

    Nevermind, I figured out how to perform the POST. :) The problem was with the URI. I did not have it formatted correctly...I didn't know the URI can only contain up to the question mark, and everything else must be contained in the POST body. I also found that even though my FM database has...
  3. amberdextrous

    ASP.NET + FileMaker, HTTP GET and POST problems

    No exception is thrown, but FileMaker generates an error that is returned to me in the String xml variable. This is the xml that is returned: <?xml version="1.0" encoding="utf-8" ?> <anyType xmlns:q1="http://www.w3.org/2001/XMLSchema" d1p1:type="q1:string"...
  4. amberdextrous

    ASP.NET + FileMaker, HTTP GET and POST problems

    Warning, I'm an extreme newbie to this stuff, I'm actually an intern so I'm still learning. I wasn't sure who would be more likely to know how to help me, FileMaker experts or ASP.NET experts, so I posted in both forums. I am trying to send GET and POST requests to a web-enabled FileMaker...
  5. amberdextrous

    FileMaker + VB.NET, GET/POST, XML

    Let me clarify...this is an ASP.NET web service. I also posted this in the ASP.NET forum to see if anyone there can help. I got my Find function working, and I am now able to run queries against the database using HTTP GET and the results are returned to me as XML. However, I am still having...
  6. amberdextrous

    FileMaker + VB.NET, GET/POST, XML

    Oh man, I really hope someone can help me. I am an IS intern and I am very new to Visual Basic, very, VERY new. I guess you could say I'm self-teaching myself on the job, but I am taking a class next semester. Anyway, my company uses two FileMaker systems that integrate. When you click...
  7. amberdextrous

    Replication: FileMaker to SQL Server

    Found out we have FMConnector, and we can use that along with FileMaker's web companion to replicate data to SQL Server. Not sure about the inner workings, but it does work. :)
  8. amberdextrous

    Using ResultSet with tables with unknown # of rows and columns

    Ahh, I did some tinkering and got it to read the data in to the ArrayList and output to a text area. public void processSQLSelect(String sqlCommand) throws SQLException { view.getJScrollPane().setViewportView(view.getJtasqlResult())...
  9. amberdextrous

    Using ResultSet with tables with unknown # of rows and columns

    Thanks, but I couldn't get it to work. Here's the code I have now: public void processSQLSelect(String sqlCommand) throws SQLException { view.getJScrollPane().setViewportView(view.getJtasqlResult()); statement = connection.createStatement(); try { ResultSet resultSet =...
  10. amberdextrous

    Using ResultSet with tables with unknown # of rows and columns

    Hello all, I'm developing an app that connects to a database (in my case, an Access database) and can run SQL queries against it (select, insert, delete, etc.). I'm trying to read data from the database using a ResultSet so I can output it to a JTable. There are several tables in the database...
  11. amberdextrous

    Replication: FileMaker to SQL Server

    Correction: FileMaker Pro 6 is what the client machines use. FileMaker Server 5.5 is where all the data is stored.
  12. amberdextrous

    Replication: FileMaker to SQL Server

    Hello all, My company uses MS SQL Server 2005 and FileMaker Pro 6. I'm developing an application that needs to access FileMaker data, but it needs to get it from a SQL Server table. So, I need to be able to automatically replicate the data from a table in FileMaker to a matching table in SQL...
  13. amberdextrous

    Label visibility toggling not working

    Thank you! I'm a VB newbie so I had never heard of this, but I did some research and it looks like it will work fine for my app. So I guess the problem was that a higher priority event was being processed before a lower-priority one? At first I was concerned because I read about the risks...
  14. amberdextrous

    Label visibility toggling not working

    This is probably going to sound like a really dumb question. In my program, the user selects values from 3 drop-down lists and hits the "Export" button, and the values are passed as parameters to a SQL Server 2005 stored procedure. The results of the query are stored in a dataset, which is...
  15. amberdextrous

    Conversion error with Varchar, datetime

    Ah, that does make sense. That may a better option. Thanks for all your help!
  16. amberdextrous

    Conversion error with Varchar, datetime

    Pure genius! This does indeed work! The only difference is I chose to use NULL in the ELSE statement, rather than a value. Then I know there's no possible way the invalid data could be returned to the user with inaccurate dates/times. Seeing as how this company wasn't even around in 1900, I...
  17. amberdextrous

    Conversion error with Varchar, datetime

    These solutions are what I was thinking needed to happen. It seemed like a problem that needed to be fixed on the user application side, but a trigger would also make a lot of sense. Yes, the values are inserted via an application. The user populates most of the fields in the table via the...
  18. amberdextrous

    Conversion error with Varchar, datetime

    Ok, I am pulling my hair out over this. I developed a VB program that has 3 drop-down lists: Agency/Client code, a start date & time, and an end date & time...the latter 2 are DateTimePickers. The user selects from these drop down lists and hits a button, which then passes the selected values...
  19. amberdextrous

    Create XML from database table in VB

    Thanks guys, I talked to my manager and ended up going more with Bob's suggestion. I took the query out of my VB code, and instead made a stored procedure in SQL Server with it, and gave column aliases to all the columns. At least that way after we deploy the application, if we find that we...
  20. amberdextrous

    Create XML from database table in VB

    I have a problem creating an XML file from a SQL Server 2005 table. This is all within a VB 2005 program I'm making. I run a query against the table and store the results in a dataset. Then I call objDataSet.WriteXML() Unfortunately, the table is poorly designed. All the columns have spaces...

Part and Inventory Search

Back
Top